Hi Fred,
Excel Data can be imported into Access fairly easily. To
do this you just go into an Access database and choose
File|Get External Data|Import.
When doing this it is necessary to have the field names
along a single row at the top, and the data listed
contiguously below.
Once in Access, the data can be appended to a single
table, or split into multiple tables, etc.
If you have a whole lot of spreadsheets, the process can
be automated by using Visual Basic Code but you would
have to give more details about the content of the files
(do they all have the same fields, different, etc), file
naming structure, what you want to do with the data, etc.
If this is where you want to go with it, you can post
back with more details and I'll see if I can help.
-Ted
-----Original Message-----
I have a zillion spreadsheets that comprise a project
that has really belonged in Access for quite some time. I
have never used access before and was wondering if,
rather than retype all row & column headings and data
into Access tables, I can simply hit a button and export
the lot?
