importing data from excel?

[2ippy]

I need to import 1600 people from excel.

as the program that we use to use was free and setup for what we needed. That has the ability to create a excel sheets with the 1600 people on.

Now all the fields are different, and i'm not sure how to do it.

When importing do you get the option to put the fields in the correct place, or do i need to edit them? and then import.

Another thing the address layout with fields will be completely wrong. I believe it used separate fields for each line of the address where in my DB i use 2 fields 1 address and 1 postcode.

 

[llkhoutx]

Import you data into a temporary table, they use an append/make table/update query to convert/position it as you want.