Importing spreadsheet cells that have multiple values


B

Brandon

I am importing information from an excel 2003 spreadsheet into a 2003 Access
Database. The rows that I am importing contain a cell that has multiple
values in it ex. (125, 131, 6330). Each value is seperated by a comma and
space.

I am trying to create multiple tables with this information. The
spreadsheet's rows will be unique records in a table (tbl1) and the multiple
values would be in another table (tbl2) linked to tbl1 with a Many to one
relationship.

Does anyone have any ideas about how I can set this up. I would like to do
everything in access and not have to run any excel macros.

Thanks in advance!
 
Ad

Advertisements

P

pietlinden

I am importing information from an excel 2003 spreadsheet into a 2003 Access
Database.  The rows that I am importing contain a cell that has multiple
values in it ex. (125, 131, 6330).  Each value is seperated by a comma and
space.

I am trying to create multiple tables with this information.  The
spreadsheet's rows will be unique records in a table (tbl1) and the multiple
values would be in another table (tbl2) linked to tbl1 with a Many to one
relationship.

Does anyone have any ideas about how I can set this up.  I would like to do
everything in access and not have to run any excel macros.

Thanks in advance!

You could link to the spreadsheet, and then use SPLIT to break the
comma-separated data into an array of values. Then you'd just loop
through the array and write the data to the proper columns in your
Access table. Open a code window and open the help file and you'll
get all the gory details on Split().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top