Importing data

[CherylC]

I am working on a database that I have not designed. There are two existing tables in Access. I need to import some additional records from Excel. Whilst trying to do this the data seems to be corrupting or only half of the data is imported. I am getting a seperate table with errors that saves in Access after trying to import the data. I've tried the query 'Append data' but it does not seem to be working. Help!

 

[FloBob]

Most likley what is happening is the feilds you are importing and the feilds you are importing too do not mach. One example would be that you are trying to import a string value into an integer column on your table. Other problems could consist of feild lengths not being long enough to support the additional data and need to be adjusted. I would recommend that you check both the table your importing from and the table your importing too for consistancy.