Creating tables based on Excel Column data.

[Achase]

I'm not sure if this is an Excel or Access question but will start off here.
I have a large excel file that contains a list of users and data related to
this. One of the columns is the city. What I would like to do is somehow
create my database tables based on that column so that all that are in New
York go into 1 table for example. I'm wondering if there is a way to do this
automatically as the spreadsheet is very large and would take literly hours
to do manually.

 

[Jeff Boyce]

Stop now! Step away from the keyboard!

Microsoft Access is not a "spreadsheet on steroids". What works for you in
Excel (one "table"/sheet per city) will cause you and Access untold hours of
headaches!

Instead, create tables in Access that are well-normalized (hint: Excel
sheets usually are not). Then import (or link to) the "raw" Excel data.
Finally, create queries (in Access) that take data from the raw import
source and append/update your more permanent (and well-normalized) tables.

Back to your original "how do I" question ... but I'm going to re-phrase it:
"How do I get all the records where City="New York"?"

Use a query with "New York" as the selection criterion for the field [City]!

Regards

Jeff Boyce
Microsoft Office/Access MVP