Import Data

[uplink600]

Good Afternoon

I'm trying to import some data from an excel sheet to a table in my database. The import wizard won't allow me to import the data into an existing table, only into a new one which is a nuisance. The data formats are the same. Any idea's what might me wrong Please.

Thanks

VC

 

[KenHigg]

Can you link to the xls and then use an append query?

Ken

 

[The_Doc_Man]

Do you get an error? Or does the wizard create an extra table to list import errors? If so, what errors are reported?

I'm guessing that you are getting a data type mismatch on a title row for a numeric field, or something similar to that. Seeing a specific error message would help us get closer to the error.

 

[uplink600]

Thanks Guys

The problem is that when going through the import spreadsheet wizard, the option to import data to an existing table is not enabled. I can only import to a new table. When I import the data to a new table all the formats are correct.

Any ideas?

Thanks

VC