472,126 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,126 software developers and data experts.

Exporting Query Data from Access 2003 to Excel 2003

Hello all,

I have data, which is separated into account numbers (ie. 10, 20, 30), but it exists in one query. Right now, I have an access macro "transferspreadsheet," which is exporting all the account numbers into one worksheet.

My question:

How can I go about exporting data from the query into excel, so that each different fund number has it's own worksheet and it's corresponding data?

Thank you. Your assistance would be greatly appreciated.
Jul 31 '07 #1
2 1961
Sub Holdings()
' Macro1 Macro


Counter = 0
Do Until ActiveCell = ""

ActiveCell.Offset(1, 0).Select
If ActiveCell = "" Then Exit Do
ActiveSheet.Paste Destination:=ActiveSheet.Range("A1")
ActiveSheet.Name = Range("A1")
Counter = Counter + 1


End Sub

So this code in excel will give me all the fund numbers which I exported from Access. I also exported all the data in my database through the transfer spreadsheet. Now I need to have the macro go into the other spreadsheets and extract that information and paste it into the new spreadsheets I created. I know this is more excel now, but any help would be appreciated.
Jul 31 '07 #2
One way to do this is to query from Excel.
I posted it here.

It's different but it work for me!!

-- Boxcar
Jul 31 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

21 posts views Thread by bobh | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.