Import/Export Specifications

[Nick]

Does anyone know if i can use the docmd.transfertext
action along with an Import/Export Specification i have
created in my Access db on a linked SQL Server table?

If not, i suspect i would have to use DTS in SQL Server.

Thanks in advance,
Nick

 

[Joe Fallon]

Not quite sure what you are trying to do.
Tranafer text is for interacting with ASCII files not SQL Server tables.
If you have a linked SQL Server table, just wirte a query against it.