Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Importing Excel data which resides in multiple rows

0 views

Skip to first unread message

tim....@gmail.com

unread,

Mar 17, 2007, 8:58:01 AM3/17/07

Hi,

I'm trying to import data into Access from multiple Excel Files. My
problem is that each entry resides on multiple rows, and the number of
rows varies with each item...for example:

But the number of "Components" varies depending on the item. At this
time, I only need to import the data for the original item, not the
components, so is there a way to import only items in which the 1st
column is not blank?

Ultimately I may need the components as well, so is there a way I can
import those and have them linked to the original item?

And my last question, these items I'm importing are in 100s of
spreadsheets, and I will have to import the information on a weekly
basis from each sheet because they are constantly changing. The names
of the sheets change as well to different version #s so I can't link
the data. Is there a way to tell access to import the data from every
excel file in a specified directory? And to have Access add a field
for the name of the spreadsheet the data came from?

0 new messages