Where do I begin?

[DragonWood]

Hello,

I have a large and complicated Excel workbook with a lot of Macros in it to automate as much as possible. I need to create a database that will store all the data contained within the workbook.

I will be using Access 2010, the Excel Workbook is currently Excel 2007. I plan on using the Excel workbook to enter data into the database until I can finish writing the Visual Basic program to replace it.

While I can use the workbook as a good reference for making the forms and reports for the data entry and retrieval, I am not sure how to go about making the tables.

 

[alansidman]

This might be a good place to start

http://www.databasedev.co.uk/tables.html

Alan

 

[DragonWood]

Alan,

Thank you I'll look through this, it looks like it could help.

Dragon