TransferText Specification File 3

[coolscan3]

Is It Possible to edit a previously created import / export specification File

 

[zevw]

Sure

you need to do it manually.

Open a file (txt, csv) whatever and the import wizard will open go to Advanvced Click on Specs edit your Spec and save it with the same name or new name and then call that spec in The TransferText Function

 

[GComyn]

yes... you can... I have a set of forms (form and sub) that will let you do it. However, I don't have a website that I can put it for you to download..

Here is the recordsource for the main form:

SELECT MSysIMEXSpecs.DateDelim, MSysIMEXSpecs.DateFourDigitYear, MSysIMEXSpecs.DateLeadingZeros, MSysIMEXSpecs.DateOrder, MSysIMEXSpecs.DecimalPoint, MSysIMEXSpecs.FieldSeparator, MSysIMEXSpecs.FileType, MSysIMEXSpecs.SpecID, MSysIMEXSpecs.SpecName, MSysIMEXSpecs.SpecType, MSysIMEXSpecs.StartRow, MSysIMEXSpecs.TextDelim, MSysIMEXSpecs.TimeDelim FROM MSysIMEXSpecs WHERE (((MSysIMEXSpecs.SpecID)=0));

This should be universal for Access.

Here is the sql for the subform:

SELECT DISTINCTROW 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 Type, MSysIMEXColumns.FieldName, IIf([IndexType]=0,"No",IIf([IndexType]=1,"Yes (Duplicates OK)",IIf([IndexType]=2,"Yes (No Duplicates)"))) AS IT, MSysIMEXColumns.SkipColumn, MSysIMEXColumns.SpecID, MSysIMEXColumns.Start, MSysIMEXColumns.Width FROM MSysIMEXColumns ORDER BY MSysIMEXColumns.Start;

The link Child/master field is the SpecID.

I got this from one of the many access websites, I just can't remember which one...

If anyone knows a way to "save" an access form in a way that it can be "imported" by access, I can post the form specs so you can use it as I see it.

GComyn