Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using SQL to query an Access DB and dump the recordset into
Excel. I use this query against different tables within the DB and vary the FROM parameter and SELECT parameters according to the table name and corresponding fields in the table. I have used this for several different queries without a problem. Now, I am going against a new table but having a problem with a field called "SIZE". I can't figure out why this is a problem but if it's set as a parameter in the SELECT statement I get a runtime error. It's not a spelling issue, hard to spell this word wrong but I checked anyway, so that isn't the problem. The only thing I can think of is that SIZE is a restricted word that's used for something else. Anybody have any suggestions as to what to check? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) |