Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

bulk insert into MS Access

843854Sep 14 2004 — edited Oct 15 2004
hi

I want insert about 5000 records into access database. A friend working with delphi show me that bulk insert is possible with writing datas in a text file and then executing the statement like
INSERT INTO GP SELECT * FROM [TEXT;DATABASE=C:\\].[bins.txt];

but when I executed the code it didn't work didn't give any error just breaks the program where it's executed
Does any one knows how to solve this problem??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2004
Added on Sep 14 2004
8 comments
505 views