Preparing data

[Munti]

Hi,

I'm building a database for adresses to institutions (health care, police departments etc) and I'm not quite sure what the best way to do this would be.

I've made a standard table with fields like: name, visiting address, post address, postnumber, postname, telephone, telefax etc.

I recieve lists (usualy in excel) with names, adresses and other unknow columns from institutions. Some have all the fields I kneed some don't. The database is to be stored in a mysql db eventually but for the moment I'm asembling it in MS Access 2000.

What would the best way be to import data from excel into that table?
1: Importing the excel sheets into access as tables? And then run some sort of query against the table and insert it into my final table.
2: Import data directly into the final table?
3: Any other way?

There may be up to 2000-2500 rows in the table.

Cheers,
Børge

 

[M8KWR]

if you set up an append query, then us this each time, with this you can map the fields across etc.

But if you have multiple files with different headers etc you may have tp set up different append queries.

Hope this helps.

 

[Munti]

I figured this one out, it was much simplet than I had originaly thought. It was just the case of arranging the columns in the excel sheet and produce a tab delimetered .txt file. Then import into the table.

Sorry for the trouble guys & gals!

Cheers,
Børge