Access 2003 - Invalid Argument Error 3001

[Matt27]

I have created a new database with 5 tables. I now want to add a sixth table to the database. I am trying to import it as an ODBC data source. However, it gets part way through importing the table into Access before coming up with the error 'Invalid Argument - Error 3001'. I have tried compacting and repairing the database (under Tools and Database Utilities) and tried importing again but this has not made any difference. Has anyone got any idea how to get round this problem?

 

[LNBruno]

Have you checked the data types? Try importing it into Excel. If that succeeds, you could try importing the Excel sheet into Access.

Be aware that there is a 2GB limit to imports.

You can check here for more info:

http://support.microsoft.com/default.aspx?scid=kb;en-us;835416

< M!ke >
Acupuncture Development: a jab well done.

 

[Matt27]

I have tried importing the table into Excel. I get to the final step which is the SQL Server Login. I type in the password and get the following message:-

Connection failed:
SQLState: '08004'
SQL Server Error: 4060
Server rejected the connection; Access to selected database has been denied.

Any ideas how to get round this problem or an alternative solution to my original Access problem??

 

[LNBruno]

Access to selected database has been denied.

Get the DBA to grant you permission?

Can you query the the offending table directly using Query Analyzer to determine if the data types match?

Can you determine if the amount of data exceeds the 2GB limit?

Could you link instead of importing the tables?

< M!ke >
Acupuncture Development: a jab well done.