Importing From Excel

[yessir]

Hello all,

I am currently working aon a database with many aspects to it and I am wondering about the importing of data once a month or so.

The company receives a file in .csv format and are willing to do some editing to it to make it compatable with the database but not a lot of editing.

I created the tables with a lot of look ups so that when they want to edit information they can do it in a form easily.

The problem thus arises that the information stored is in some cases mainly numbers for lookups. Importing the inforamtion from a .csv file woule contain the actual context not the ID (ie. Iron not 3, or Plane not 35)

Is there a way to streamline this so that it associates the text in the .csv with the proper index for the lookups?

Is this the best way to do this?

Should I just have the data in hte table not in lookups?

ANY and ALL help is appreciated,

Thanks
~

 

[namliam]

Import into a temp table and convert the text to numbers using updates before appending to the fixed table

BR