Convert Excel to a Current Access DB

[Guest]

How do I convert my current Excel spreadsheet that I use for data entry into
an Access database that I am currently developing? Because my data in Excel
is un-normalized and my data in Access will be in third normal form, will I
have to manually convert the data using SELECT and INSERT statements? I want
to be able to keep the current data in the Excel spreadsheet, though.

I am using Office 2000.

Any help would be appreciated. Thanks.

 

[Douglas J. Steele]

Yes, you'll need to convert the data manually.

I'm not quite sure, though, what you're trying to do. Are you saying you're
going to have data in Excel and bring it into Access for manipulation and
still have the Excel spreadsheet (which may be updated independent of the
data in Access)?

 

[Guest]

No, my goal is to get rid of the spreadsheet all together and just use Access.
Thanks.

 

[R]

How do I convert my current Excel spreadsheet that I use for data
entry into an Access database that I am currently developing?
Because my data in Excel is un-normalized and my data in Access will
be in third normal form, will I have to manually convert the data
using SELECT and INSERT statements? I want to be able to keep the
current data in the Excel spreadsheet, though.

I am using Office 2000.

Any help would be appreciated. Thanks.

Say you have one excel sheet with 9 columns (a,b,c,d,e,f,g,h,i) that are
your whole unnormalized database as it exists today in excel. Now say your
access db has three tables (1,2,3) , three columns each. Take your
spreadsheet and copy the data in columns a,b,c which happen to be the data
that needs to go into table 1. Paste them into a new worksheet or new
spreadsheet. Do that with the other columns into their own worksheets or
spreadsheets. Now you should be able to import into access. If you are
really bad off and have composite columns like citystatezip all in the same
column rather than broken out, you will need to parse those out as well.

hth