Convert Excel to Access

  • Thread starter Thread starter plb2862
  • Start date Start date
P

plb2862

I am using Office XP Pro on a W2K system. I have an Excel workbook with
several labeled sheets and I want to convert the workbook into an access
mdb.

My delima begins with:

How do I convert and keep formulas if possible.
Then, there are the options of ADO or jet engines.
And, finally I will want to be able to go back and use the data to do graphs
on reports.
 
I am using Office XP Pro on a W2K system. I have an Excel workbook with
several labeled sheets and I want to convert the workbook into an access
mdb.

My delima begins with:

How do I convert and keep formulas if possible.
Then, there are the options of ADO or jet engines.
And, finally I will want to be able to go back and use the data to do graphs
on reports.
Click to expand...

Excel is a spreadsheet, a good one.

Access is a relational database.

THEY ARE DIFFERENT. Access is not "a big spreadsheet"! A table
datasheet is *not* suitable for formulas. Applying spreadsheet logic
to the design of an Access database will cause you far more problems
than benefits!

You can use File... Get External Data... Import to import the *data*
in your spreadsheets into an Access table (or Export to send it back
to Excel); but you should NOT treat the table as if it were a
spreadsheet. Instead, normalize the data, probably into two or more
tables; and create Queries to do your calculations.
 
Back
Top