ACCESS QUERY INTO EXCEL

[JonRowland]

Hi, can anyone help?

I have a query in Access which users need to analyze in Excel. That bit is simple.

When sending the query to Excel only the first 255 characters are taken. Is there any way more that 255 characters can be sent to Excel?

Thanks
Jon

 

[Philem]

Hullo. Just to chime in on the "passing a parameter" topic: I've got a db (A97) getting a parameter from a specific cell (E97). Now, the code that does this sits in ACCESS, not in Excel. I've found that Access has good legs when it comes to being an automation server. Excel cannot grok Access that well, but Access can dump straight to an Excel sheet just fine.

Yet another option!

HTH

P

 

[bat17]

I did it in a similar way because I found that I could extract the data in VBA and put it in Excel by remote faster that MS query ran anyway. If you can run code in Access to do it, I assume that you can do it from Excel in the same way. I cant check this out untill after the weekend though. Shout if you need more.

Peter

 

[lord of the badgers]

sorry i'm very late in replying...

can you not set up a routine in Access to output the query as a table using a MakeTable query (and then MSQuery looks at the table)... yes, this is now dependant on you running a routing in access (which in my own case is fine and dandy), so appreciate it might not be a good answer..!