Import Problems

[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.

 

[Rob Oldfield]

It would help if you say exactly what the error message is, and the code
that you're using to trigger the import.

 

[Rob Oldfield]

And the code that's triggering the error is?

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