Query Problem

[Tony via AccessMonster.com]

I have an issues with my Microsft Access Database. It's an infentory
database, storing all the information about our hardware here at the store.
The files have been brought into the computers. We have 11 computers in our
office. Each computer has Microsoft Access 97, 200, XP, and 2004 on each
computer. We recently compacted all of our databases into one database.

My question is, is there a way to excract our information from the new
databases back into an excel spreadsheets? We have Microsoft Excel 97, 200,
XP, and 2004 on each computer. I wanna bring the data from Microosft Access
databases into the spreadsheet.

Thank you,
Tony

 

[Ken Snell \(MVP\)]

See TransferSpreadsheet in Help file. This allows exporting of a table or
query into an EXCEL file.

 

[Guest]

You must mean 2003, there is no Access 2004.
Use the TransferSpreadsheet method for VBA
Use the TransferSpreadsheet action for Macros
Manualy, File, Export

 

[Jeff via AccessMonster.com]

Tony, you damn bastard!

What have you been up to?

It's been a while since we hooked up at IHOP. We'll have to do it again

So it looks like your still in school?

You damn bastard!

Jeff