Excel to Access link

[Paul Hammond]

This is more of an excel question, but it's related so I am cross posting here.
Any help is appreciated.

I keep trying to import data from an Access database and I continually get
the same error.

"ODBC Microsoft Access Driver The text file specification "Inserts" does
not exist You cannot import., export or link using this specification."

Well the spec does exist, the queries run just fine in Access. The data
source are linked text files using the "Inserts" specification, which
definitely does exist.

Sumpens wrong, but danged if I know what it is.

Any ideas?


TIA
Paul Hammond