concatenate columns values from excel file into field in database

[megatronixs]

Hi all,

I'm trying to import an excel file that has some columns that I need to concatenate into one field in the access database.
How could this be done. I know I could do it before hand in excel and them import it to access, but if this can be avoid, would be really great.

Greetings.

 

[Ranman256]

Link in the excel file as a table.
Build an append query, in it, concat the 2 fields into the target field.

 

[megatronixs]

Hi Ranman256,

I did actually import the excel file into a table, then run the append query with the concat and that gets into the main table. works really nice

Greetings.