Import Text with Spec File

[Guest]

I am trying to import a text file and have a Spec file that defines the field
properties. When I import the text, I want to also populate a date field in
the import table. The date field is not defined in the text file. I want to
populate the field when I execute the TransferText method. The value of the
date field would be the same for every record.

If this can't be done, is there anyway to do this without creating a schema
file?

 

[Ken Snell \(MVP\)]

Import the text file to a temporary table, then use an append query to copy
the data to the permanent table -- and add a calculated field to the append
query that writes the desired date into the date field.