Problem with importing into access

  • Thread starter Thread starter Dominic
  • Start date Start date
D

Dominic

I am trying to import information into my acces table for
product information. The information is in 3 files, 1st
has the item number, price, name and a couple of fields I
am not using. The second file contains the item number and
desciption, the 3rd file is a gif of the item with the
name of the gif being the item number. I knwo I need to
create 3 queries to update the information I need, but I
don't know how I can get the descriptions in as they arein
different files. I have the same issue with the pictures
too.

Can anyone help?

Thanks
Dom
 
Might be easiest to create a temporary table to receive the data, update it
from the other tables, and then copy the data to the permanent location.

Assuming that the Item number is unique, I first would import the first file
into the temporary table.

Then link to the second and third files as linked tables.

Create an update query something like this:

UPDATE TempTableName
INNER JOIN File2
ON TempTableName.ItemNumber =
File2.ItemNumber
SET TempTableName.Description =
File2.Description;

Then you'd create a second update query similar to the one above but using
the third file. The "trick" here may be that you may need to parse the
ItemNumber from the .gif file name? Post more info about this and we'll
continue.
 
Back
Top