SQL table named with reserved keyword in Excel

100 views Asked by At

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?

0

There are 0 answers