Web Development

Ask something
Discussion Locked

Import Access record in mulitiple Excel

0 helpful
7 replies

by anthonys 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have 50-100 lines of data records in Access. I need to fill in a form in Excel with one record from my Access database. It is basically a report but instead of creating it in Access I need to put it in Excel. I am sure this is a simple excercise that I can't figure out.

7 replies

by dr. dale

In Access, open up the table or query in which the information is stored and choose tools, office links, analyze it with Excel.

by tarran

If I understand you correctly, you wish to open multiple workbooks, each containing a form filled in with information from 1 record from a table in an Access database.

I think that you would be best served by writing a macro.

The way I would do this is:

Record a macro as you manually create a new workbook and import the data into it. Then edit the macro. This will allow you to see the object calls within Visual Basic for Applications.

Use the automatically generated code as a guideto write a macro to carry out the operation you desire. For example, you can alter the data returned in the query by replacing a portion of the SQL call string with a variable whose values are manipulated by the macro.

Take some time to browse the online help in the visual basic editor. There are meny gems of object methods & properties buried in it.

I hope this is helpful.

This discussion is closed to new replies.