A2003 write to Excel 2000 file?

[bulrush]

I have A2003 installed on my Win XP machine, but all other Office apps are Office 2000 (Excel 2000, Word 2000).

I would like to take a table/query in A2003, and write it to a .xls file with a single tab. Each field in Access would be a column in Excel, and each record in Access would be a row in Excel. Very simple in concept.

How do I do this?

This would eliminate the step of the user taking my tab-delimited file and manually importing it into Excel.

I normally work with DAO recordsets so ADO code will not help me much.

Thank you.

 

[pbaldy]

The simplest solutions would be TransferSpreadsheet or OutputTo. More info on both in VBA help.

 

[bulrush]

I can't do that. I have to loop through the spreadsheet, do complex calculations not allowed in a query, and manually write each record to a new row in the spreadsheet.

 

[JPearson]

Whats preventing you from perfoming the calculations after the transfer or output into excel?

 

[pbaldy]

That directly conflicts with what you said in the original post. If you want to go line by line, you can use what's called "automation". This should get you started:

http://support.microsoft.com/kb/129304