Import Problems

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have a sql table in which I import records. I get an error messages that
stops the import after 8,000 records are imported .- something about jet
engine. I restart and import again with the same error message and same
number of records imported. Usually, I have to import over 20,000 records
during an import session.

I use Access 2002 front end- SQL Server 2000 backend with Windows XP as
operating system.

How do I fix this problem? Any assistance is greatly appreciated.
 
It would help if you say exactly what the error message is, and the code
that you're using to trigger the import.
 
And the code that's triggering the error is?

For reference, you shouldn't post binary files to newsgroups.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing data 1
Problem with Import/append 2
Windows 7 Black screen,no start up. 2
Access Access 2010 import/append data into table w/o overwriting existing records 0
can't delete record if checkbox is false 1
Problems Importing Govt. XML Files 1
Importing Delimited Text File Error Help!! 3
You must use the dbSeeChanges option with OpenRecordSet whenaccessing a SQL Server table that has an 1

Back
Top