Error message when trying to import table.

[needadvice]

When I try to import a table from another database I'm getting the following message. "You tried to assign the null value to a variable that is not a variant data type."
Does anyone know what is causing this and how I can get past it?

 

[ssecca]

My only thought for what it is worth is try importing the table structure and data seperatly. Thsi may at least give you the opportunity to modify the structure to acept the data.

Good Luck
ssecca

 

[needadvice]

How do you import data only?

 

[ssecca]

What is the source data currently in?
ssecca

 

[needadvice]

Access 2000

 

[ssecca]

If you right click on the table name and copy. Then go to the DB that you want the data in right click in a blank area of the datbase window while on the Tables tab you will getr the option to paste. you then get the option to paste all or just the data or just the structure.

Option two would be to cut and paste to Excel then to the new access table.

Option three would be to create a connection between the two data bases and do a query update or append between the two tables.

Good Luck, Hope this helps
ssecca