G
Guest
I am using Office 2003 on Windows XP (ADO 2.8).
I am automating Access from Excel and I would like to retrieve the field
names from a DB using SQL. Right now, I am returning a single row in a
recordset (using TOP), then obtaining the field names.
QUESTION: Is there a generic way to construct a SQL statement so that it
will always return zero records, no matter what Access DB is being queried?
Then I would have an empty recordset (but with accessible field names). I am
assuming you could put something in the WHERE clause, for example:
SELECT * FROM Table WHERE ????
In this scenario, you know the file name, its location, and the table name.
Could someone please post example SQL that would always return ZERO records?
Thanks much in advance.
I am automating Access from Excel and I would like to retrieve the field
names from a DB using SQL. Right now, I am returning a single row in a
recordset (using TOP), then obtaining the field names.
QUESTION: Is there a generic way to construct a SQL statement so that it
will always return zero records, no matter what Access DB is being queried?
Then I would have an empty recordset (but with accessible field names). I am
assuming you could put something in the WHERE clause, for example:
SELECT * FROM Table WHERE ????
In this scenario, you know the file name, its location, and the table name.
Could someone please post example SQL that would always return ZERO records?
Thanks much in advance.