insert microsoft access tables into excel spreadsheets

[jagjot]

Hi Folks,

I have MS Access database with 5 tables in it.
And the are few people on my network using excel spreadsheet, which i populate manually everyday from MS Access tables.

Looking for any way i can update the tables and spreadsheet data will will updated as well. and i want to use query in excel to filter data..

Is this possible.
please help...

Thanks in advance.
Jag

 

[Rabbie]

It may be easier for you to have queries in Access that produce the data and then export these to Excel.

 

[jagjot]

Can you give me an example...how can i export automatically...
i have queries.

but i want to make it automatic process.
Please...

 

[Rabbie]

Search Access VBA help for TransferSpreadsheet. That seems to do what you are looking for.

 

[qdogfball]

Ex)

TabName = "RRA"

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qry-Task-  Daily Report", "c:\Task Reports\" & "Task Cor " & Format(Now(), "mm-dd-yy") & ".xls", True, TabName

The DoCmd is all one line.

The query is Qry-Task-Daily Report, the location you want it comes next with the Date. I have added a tabname to help when people are in it! Just watch out for the " (quote) as you need them where they are at!

Hope that helps!