Importing from Excel to Access

  • Thread starter Thread starter Rochelle
  • Start date Start date
R

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.
 
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.
 
Back
Top