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.
 
Back
Top