Excel 2000 QueryTable to MSAccess SQL with "TRANSFORM"

D

DSMessenger

In Excel 2000 using various QueryTables to link to Microsoft Access 2000
Database.

No issues ... when need to change various fields simply rebuild the SQL
String in Excel and requery database.

However wanted to use "TRANSFORM" so built the initial Query in Access then
copied over the SQL String back to Excel. It kept coming up with messages
about an Error associated with "TRANSFORM". Haven't got Excel 2000 here at
the moment so can't get exact wording of Error or try to again replicate.

Trying it again now in Excel 2003 and works fine. Assuming I haven't made a
typo is there any difference in Excel 2000 which would account for this ? Can
TRANSFORM Queries not be done in this earlier version ?
 
D

DSMessenger

Sorry ... don't know how to delete a post once created. I figured out what
was wrong with the SQL String. Slight difference between Access and Excel.
All fixed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Reset QueryTable error on empty text file 1
Running an Access function (with parameters) from Excel 6
Can't change connection property on querytable 4
QueryTable Refresh Failed 0
Non-exclusive file access via QueryTable 0
QueryTable connection using ADO Recordset 3
Excel as front end and SQL Server as back end 0

Top