Next week at work I am going to start to build a small DB which will
(hopefully) allow me to import data into a few tables, so I can do some
complex queries and build some dynamic reports.  I think I can pretty much
take care of the queries and reports, but I think I need a little assistance
with the initial importing process.  I don’t have a whole lot of experience
importing data into Access.  I did some importing before, but mostly from
Excel files.  Also, on a few occasions, I imported some rather large amounts
of data (up to 2GB) from a massive DB, but I was pretty much just using what
someone other than myself had set up (the DB actually built more and more
tables as more and more data was imported).  I am hoping to get a basic
overview of how to set up a few generic tables within the next day or so, and
import data into those tables when I get back to the office early next week.  
Is it possible, for instance, to just set up a table with 2-3 data fields,
simply as placeholders, and then just let Access build the rest of the data
fields as it runs through the import process?  I was thinking of using an
AutoNumber as the Primary Key and set the rest of the fields as text.  Can I
just let Access build the data table automatically, and rely on it to expand,
or grow, as more and more data comes in?  As of now, I don’t know what all
the fields will be.  Also, can I set up a few tables in this fashion, and
link all tables via AutoNumbers in each table?  I’ve done lots of VBA
programming in excel, and I know how to add sheets dynamically, as more and
more data is imported into a workbook, but I don’t know how to do this in
Access.  Is there an online resource that goes through the entire Access data
import process?

Regards,
Ryan---