issues when importing from excel

[Ignace]

HI,



it might be a basic question but i am stuck with the following.

i am trying to import record from excel into my database. as an illustration my excel list looks like this

column 1: John
column 2: Perkins
column 3: John Perkins

my access database has the following field and attribute

field 1: first name (Text)
filed 2: Last name (text)
field 3: File as (calculated (which is the combination of first name and last name as field 3 in excel)

when i try to import i get the famous unparsable record on the thrid field.
i tried importing just column 1 and 2 from excel (hoping that Access would generate the filed 3 automatically): no success
i tried importing with and without the formulas in column 3: no success

how shall i do this?

thanks for your help

Ignace

[ssanfu]

Just import columns 1 & 2. Don't import or store column 3. Since you can "calculate" the full name at any time in Access, it doesn't (and shouldn't) be stored.

BTW, you also shouldn't use spaces in object names.....