R
ryguy7272
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---
(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---