Bulk Insert Fixed Length Text File
Prepare Data for Bulk Export or Import (SQL Server). BULK INSERT statement, or INSERT. To import data from data files with fixed-length or fixed-width fields. This topic illustrates the use of a format file in bulk. Unicode text strings (that is, either fixed-size or character. Format-File Option. Bulk insert fixed width fields. I think you need to define a format file. BULK INSERT TableA. Import a text file into SQL Server with the size of fields.
See More On Stackoverflow
I would like to issue this command: BULK INSERT TableA FROM 'C: Temp TableA.txt' WITH (FORMATFILE='C: Temp Table A.xml'); But I haven't moved to SQL Server 2005 yet. SQL Server 2000 doesn't accept xml format files. How do I replace this following?
Fixed Length Record
Hi, Can anyone tell me how to 'bulk insert' a text file with fixed-width? I used the following for 'bulk inserting' a tab-delimited file: BULK INSERT table name FROM filename to insert WITH (FIELDTERMINATOR = ' t',FIRSTROW=2,ROWTERMINA TOR = ' n') Now, I need to do the same for a fixed-width text file but I'm at a loss on what value to use for the FIELDTERMINATOR. My apologies if there's a similar question that has been posted before.
I really need the solution now and I don't have that much time to browse all the topics under MS SQL. I hope you understand guys. Thanks for all your help.