By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,824 Members | 1,590 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,824 IT Pros & Developers. It's quick & easy.

Bulk Import using Text file as input (OLEdb connection)

P: n/a
With the help of you, I've been able to successfully load my database with the contents of a "comma" delimited file. It loads about 5000 records in about 3 seconds:) Now I have another problem. The file I will be importing into SQL Server is serparated by "|" vertical bar opposed to "," comma. When I run my program with the comma separated text file, works great, but when I try to use the same process to import the | (vertical bar) it only imports the first field. I suspect is has to do with the Extended properties of the OLE DB Jet connection.

Here is what I have
"string tTextConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myDirPath;Extended Properties='text;HDR=No;FMT=Delimited'";

Can you help me import my file using the same method (Bulk insert using OLE DB for reading text and going into SQL Server DB) but for | vertical bar delimited files?


Sep 28 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.