G
Guest
Ok, I'm sure this is easy for you guys! I'm working in Microsoft Excel 2000
and Access 2002. I need to access and copy data from an access table
automaitcally. I’ve used VB a little. Here is the situation:
I jhave a user interface in Microsoft excel. It pulls from a table in the
spreadsheet. I need to updfate the table in the spreadsheet with data that
changes weekly in the Access table.
The Access table is named “Correspondence Log†and the table within this
database that has the data is called “HousingAuthorities†. The
spreadsheet name is Contact Information.
How would I copy data from this Access table to the Excel spreadsheet via a
macro?
and Access 2002. I need to access and copy data from an access table
automaitcally. I’ve used VB a little. Here is the situation:
I jhave a user interface in Microsoft excel. It pulls from a table in the
spreadsheet. I need to updfate the table in the spreadsheet with data that
changes weekly in the Access table.
The Access table is named “Correspondence Log†and the table within this
database that has the data is called “HousingAuthorities†. The
spreadsheet name is Contact Information.
How would I copy data from this Access table to the Excel spreadsheet via a
macro?