SQL table named with reserved keyword in Excel

Asked Sep 11 '13 at 18:53

Active Nov 26 '13 at 17:03

Viewed 97 times

I have the following code I would like to put into Excel:

SELECT Trans.TransactionNumber, Trans.CustomerID, Trans.Total, TrE.ItemID, TrE.Quantity,     TeE.Description
FROM "Transaction" AS Trans
JOIN TransactionEntry AS TrE
ON Trans.TransactionNumber = TrE.TransactionNumber
JOIN TenderEntry AS TeE
ON Trans.TransactionNumber = TeE.TransactionNumber

The problem is that whoever created the DB named one of the tables as Transaction. I can access it SQL itself with double quotes. But every time I try in Excel (either w/ double quotes or square brackets) it tells me "Could not add the table Transaction."

Is there a way around the keyword issue in Excel?

asked Sep 11 '13 at 18:53

Justin Burgard

have you tried using `[Transaction]`? – Rômulo Spier Sep 11 '13 at 18:55
I believe the above comment will work, but have you also considered placing that select statement within a sub query? – websch01ar Sep 11 '13 at 18:58
I have used the square brackets but it gives me the same error. I'll look at the sub-query. – Justin Burgard Sep 11 '13 at 19:34
It works now with the double quotes. Not sure why. Thanks for the help. – Justin Burgard Sep 11 '13 at 21:00

SQL table named with reserved keyword in Excel

0 Answers0