syntax error in from clause

[jskamm]

Using access 2007. Below is a query I've used in the past in my access database. Now I'm getting an syntax error message in the FROM clause, the FROM statement becomes highlighted when I try to save.


Can someone tell me what's wrong with the From clause.

INSERT INTO ildonotcallaccesstable ( phonenumber )
SELECT ac & phone AS phonenumber
FROM (TEXT;DATABASE=C:\do not call list) ildonotcalllist9_18_12.txt;

[jskamm]

Forgot to mention,

I'm importing a text file into the access database. The text file has two columns, the first column is labeled ac, second labeled phone. I'm importing the two columns from the text file into one column into the access database. The column in the access database is labeled phonenumber.

[jskamm]

Never mind, I fiqured it out. It should have been:

INSERT INTO ildonotcallaccesstable ( phonenumber )
SELECT ac & phone AS phonenumber
FROM [TEXT;DATABASE=C:\do not call list\].ildonotcalllist9_18_12.txt;