casting - Importing Date Data as Text - Tab Delim to Access -


I have tab-delimited output from an external program that is one of the (non-negotiable) # / #, Which is 1/1, 1/2, 3/5 etc. (one in two, three out of five etc.)

The entry is incorrectly interpreting it as a date, where it needs to be interpreted as a lesson. If I ask to store it as a date (see the field type in the table) it still does not import properly.

How do I tell in import steps, "interpret this field to assume that you are using the Import Wizard, you should be able to specify the data type for each field in the source file This is a text file, you can also create "Import Specification" for the file where you indicate which fields are imported and their data type. If this is a file format to work with you in future, you can also use the import tip via VBA if you use the Docmd.TransferText method.

Comments