Location of the Import Specification 1

[Cornelius19]

When you click on File/Get External Data/Import and you choose a text file, the Import Text Wizard appears. You click on Advanced and can set up an Import Specification and save it. I guess this is saved into a text file. Where is that text file? I would like to document the process this specification is used in and it would be convenient for me to include it to the documentation as a text file.

Thanks,

Cornelius

 

[Remou]

The information is saved in system tables MSysIMEXSpecs and MSysIMEXColumns.

 

[scorpio1769]

Create a new query an put this in the SQL. You can then export the results. It's a start.

SELECT MSysIMEXSpecs.SpecName, MSysIMEXColumns.FieldName, MSysIMEXColumns.Attributes, IIf([datatype]=1,"Yes/No",IIf([datatype]=2,"Byte",IIf([datatype]=3,"Integer",IIf([datatype]=4,"Long Integer",IIf([datatype]=5,"Currency",IIf([datatype]=6,"Single",IIf([datatype]=7,"Double",IIf([datatype]=8,"Date/Time",IIf([datatype]=10,"Text",IIf([datatype]=12,"Memo",IIf([datatype]=13,"Hyperlink"))))))))))) AS Expr1, MSysIMEXColumns.IndexType, MSysIMEXColumns.Start, MSysIMEXColumns.Width, MSysIMEXColumns.SkipColumn
FROM MSysIMEXColumns INNER JOIN MSysIMEXSpecs ON MSysIMEXColumns.SpecID = MSysIMEXSpecs.SpecID
ORDER BY MSysIMEXSpecs.SpecName, MSysIMEXColumns.Start, MSysIMEXColumns.Width;

 

[Cornelius19]

Thanks a lot!

Cornelius