Excel to Access convertion question

[wabtrainer]

Is it possible to convert a number of complex spreadsheets (each with a number of worksheets) with lookups btween these spreadsheets into a better organised Access database without loosing the formulas and lookups?

I know its a bit vague, I,m just trying to scope how hard it will be to try and turn an unweildly set of connected spreadsheets into a database?


If you want to be a bear:
Be a Grizzly!

 

[xlhelp]

Why not use the Excel workbooks as Tables in your Access?

 

[SkydivingSteve]

You can't, to the best of my knowledge, simply convert the Excel workbook to Access links and all. You'll lose the formulas and lookups. The best I can suggest is that you do as xlhelp suggests and import or link the Excel tables and then recreate the relationships (and normalise as you see fit).

There may be a third party tool to do what you're looking for, but sadly, I've never seen it.

Steve

http://www.fontmadness.com