Import from Excel spreadsheet

[Guest]

I have an Excel sheet where column A holds a customer ID, and the following
columns holds the item number the customer has ordered. The number of items
pr. customer varies.
I would like to import this into an Access table creating on record pr. item
number. Each record should consist of customer number and item number. One
row could then result in everything from 1 to 100 records.
How can this import be done?

 

[Danny J. Lesandrini]

You need to use automation. Send me an email at (e-mail address removed)
and I'll send you some code, if you don't have any Excel automation examples
laying around.

 

[Danny J. Lesandrini]

Actually, here's a link to the code and article ...

http://amazecreations.com/datafast/articles/import/excel.htm

This article isn't due to be published at DBJ until next week, but
here's the preview. The code in the download file will get you
started. You'll have to walk the columns for each row, checking
for an item and if found, insert into your table. My example doesn't
do this, but it's not a leap to get where you want to be.