How do I find out which Spec is being used?

  • Thread starter Thread starter Steven Britton via AccessMonster.com
  • Start date Start date
S

Steven Britton via AccessMonster.com

I have a file that is a .csv that is linked to my database. I want to
change it to an import and am not sure what specification is being used, is
there a way to find out which one it uses?

thanks
 
Look at the Connect property of the TableDef associated with the linked
table. If an import spec is being used it should be included in that as
(IIRC) the DSN parameter.
 
I don't know how to do what you said... Please expand a little more.
 
Hit Ctrl+G to get to the Immediate pane. Type something like

? currentdb.TableDefs("XXX").Connect

where XXX is the name of the linked table. With luck you'll get
something like this


Text;DSN=YYY;FMT=Delimited;HDR=NO;IMEX=2;CharacterSet=437;DATABASE=C:\TEMP

where YYY is the name of the specification.
 
Hey thanks, that is new and different.

Worked just as you explained, and provided the answer I needed.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Saving Import/Export Spec 1
Which is the best MBOX Converter Tool different formats conversion? 4
import csv conversion & import spec error 1
Import Spec does not exist 3
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Import Specs Changed "Magically" in Midst of Loading Sequence 3
how to create an import spec 1
Export Spec Problem 1

Back
Top