Test to see if file spec exists through code?

[dmh_test1@yahoo.com]

Anyone know of a way to do this through code?

[dmh_test1@yahoo.com]

Re: Test to see if file spec exists through code?

On Aug 19, 12:38 pm, dmh_te...@yahoo .com wrote:

Anyone know of a way to do this through code?

I sent that prematurely. To be specific, I'm trying to see if a
"SpecificationN ame", as you would create in the import/export wizard
and use in TransferText, exists (before using it in TransferText.) I
would hope it's either in a system table or in a custom database
property- or anything that I can access through code. Any ideas?

[dmh_test1@yahoo.com]

Re: Test to see if file spec exists through code?

On Aug 19, 12:38 pm, dmh_te...@yahoo .com wrote:

Anyone know of a way to do this through code?

Figuredout how, quite simple actually:

table is MSysIMEXSpecs
field is SpecName


Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordse t("select SpecName from MSysIMEXSpecs",
dbOpenSnapshot)
rs.MoveFirst
MsgBox rs!SpecName
rs.Close