getting data from a Microsoft Access table

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA - retrieve data on last create named range from previous inserted named range 0
Getting information from access table in excel 1
How to export table from outlook into ms access table? 0
Excel ODBC driver created table/inserted data lost on application 1
Access #Error & Excel Pivot 0
Best way to get data from Access 2003 to Excel 2003 6
Automatic Prompt for Users to Save 8

Back
Top