Importing from Excel to Access

[Rochelle]

I have an Excel spreadsheet from was created from another
database awhile ago. I would like to import this info
into Access. One of the fields in Excel is a multi-value
field and I'm not sure if I can split these value to be
individual fields in Access. Please advise.

 

[Joe Fallon]

Yes it can be done, just not during the import itself.
I typically import Excel data to a "staging table" and then use Access
queries to parse and format the data as I load it into the "real table".

Splitting up the multiple values depends on how they are separated.
(Comma, space, ~, etc.)
Then use Access functions to identify the delimiter and split the string and
send each piece where it needs to go.