Import received Data

[motleyjew]

I need some advice on what is the best way to import data. I have a access 2003 database that tracks converter boxes that my company sends out for repair. Currently they have a excel file that is imported into the tables which establishes the converters that are out being fixed. When they come back from service they enter the date manually from the packing slip by searching for the converter in the forms search. We now are able to get the received converters on a excel spreadsheet. Is there a way to import the date from the excel file to the access table. Any advice would be great.

Gregg

 

[Dennisk]

The easiest way is to link the Excel Spreadsheet. then you can treat it just like any other table. However if you automate it you have to ensure that the format is consistant.

 

[motleyjew]

So is it best to have 2 seperate tables. One with Date shipped and the other with date received and use a comparison query to do reporting? Right now I just have the 1 table and the date received field is in it as well as date shipped. I wanted to see if there is some type of way to just import the date received field from the excel sheet to the existing access table. If not, I can just redesign the database with another table. Thanks for your help....Gregg