Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 QueryTable to MSAccess SQL with "TRANSFORM"
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 QueryTable to MSAccess SQL with "TRANSFORM"
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. "DSMessenger" wrote: 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I auto transform sets of data? (change "female" to "f") | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel QueryTable Refresh Causes "Choose Profile" Dialog to Appear | Excel Programming | |||
"Reference is not Valid" when calling fast fourier transform | Excel Programming | |||
I want Excel to transform the symbol "½" to .5 for me. Possible?? | Excel Discussion (Misc queries) |