Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet as form using Access for records
I have an Access database that has a lot of records. We are going to set up
a form using Excel that uses field data for each cell on the Excel form. I can't figure out how to link the database and the spreadsheet to do this. How can I make the field called "Date" go to cell G7? Each record on the database should be able to populate the entire worksheet, which will be saved as the worksheet for that particular record. And no, this is not my idea. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
Auto refreshing and printing a form with data from each row of a spreadsheet | Excel Discussion (Misc queries) | |||
Finding and killing all Access queries in an Excel spreadsheet | Links and Linking in Excel | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) |