Re: Importing into multiple linked tables
- From: "Roger Carlson" <RogerCarlson@xxxxxxxxxxxxxxx>
- Date: Tue, 11 Mar 2008 14:06:33 -0400
Transforming data from a flat-file into a normalized structure is always a
challenge and there is no single answer. It depends a lot on your specific
circumstances and data. However, I've had some success with this method.
Import the excel spreadsheet into an Access table. If there is a problem
with datatypes between Excel and Access (this does happen sometimes), you
may need to save the Excel as a CSV and import it that way.
Next, use the Table Analyser Wizard (Tools>Analyze>Table) (A2k-A2K3) to
split the table. Make a copy of your table first, because the Wizard
doesn't always work the way you think it should. Play with it until you get
it to work the way you want it to. One of the things it will do for you is
add a foreign key and enter a value to create the relationship. It insists
on creating this as a LookUp field, so I would remove that immediately (the
LookUp property, that is).
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
"markmarko" <markmarko@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
We are transitioning from keeping data on excel spreadsheets into an
database. Going forward, all data will be typed directly into database,
need to import our previous data for accurate YTD info.
I can see how to import into a single table. How can I import into
tables? The tricky part is --- How do I make the connections? How can I
the correct foreign key in sales details, for example?
- Prev by Date: Exporting Email
- Next by Date: Re: Importing into multiple linked tables
- Previous by thread: Exporting Email
- Next by thread: Re: Importing into multiple linked tables