Access 2003 to Excel

[Guest]

Can I populate an Excel Worksheet with Access data?

I'm dealing with a very elaborate series of government forms, and wondering
if I can use the information in our database to automatically populate the
form. I am not talking about just making a spreadsheet out of a table.

If this is possible, can someone give me pointers as to where I would go to
get information about how to do this?

Thanks so much.

 

[Guest]

Can I populate an Excel Worksheet with Access data?

I'm dealing with a very elaborate series of government forms, and wondering
if I can use the information in our database to automatically populate the
form. I am not talking about just making a spreadsheet out of a table.

If this is possible, can someone give me pointers as to where I would go to
get information about how to do this?

Thanks so much.

You can use MS Query to populate an excel workbook with Access data. Type ms
query into Excel help, for additional info. Also, if you decide to go this
route, check out some of the Excel news groups. You may find additional
expert advise there.

Rosco