SETTING DATA TYPE IN TABLE

[rstitzel]

I have a procedure that imports a text file from a web server
ImportTable:
'Import orders text file from web server
DoCmd.TransferText acImportDelim, "novorders Link Specification", "tbl_weborders", "\\rose-bdc\inetpub\

http://wwwroot\_private\novOrders.txt",

True, "".

All the fields come across as data type = TEXT. Which is fine for all the fields except the date field. I want to be able to import the table and then change the data type for that one field from TEXT to DATE/TIME. How can I do this through VBA?

Thank you....

 

[MichaelRed]

AFAIK, you canot actually "change" the data type of a field in a tabledef (TABLE). You would need to either

[tab]add a new field and transpose the text info to the new field (thereafter ignoring hte original field)

[tab]Format the existing text field as date type in all usage ([queries | Forms | Reports | ... ]

[tab]Import via a specification (.INI) file

[tab]Import to a temp table and append from the temp table to your final destiniation via code or query which accomplishes the conversion

[tab]other transforms not in (my) mind at present

MichaelRed
m.red@att.net

Searching for employment in all the wrong places