Converting from Excel spreadsheet...

[chuckbjr]

Not sure if I'm in the right forum or not... I have an existing Excel Spreadsheet that I'd like to move over to Access for record keeping purposes. Currently the workbook has 3 worksheets - one for inputting data, one for modifying calculations with lots of formulas and dependencies and one to print out and send to our customers. I've never really tried doing anything like this before and was hoping someone had experience in having a spreadsheet grow out of it's program before?

Thanks.
c b j

 

[Darrylles]

Hi,

There is a wizard that will do this for you (it will even create the tables for you whilst it does this).

File -> Get External Data -> Import

You'll probably come across a few 'niggles', but just come back here with specifics.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk