Importing Tabbed separated

[patfee]

Hi,
a tabbed seperated file i'm importing uses two date columns with yyyymmdd format.

how can i perform a file import in a way that access recognizes these column data as a date?

Thanks
Patrick

 

[GrahamHills]

If you import using a two stage strategy. You can import to a holding table, using text fields right the way through, then on the second stage moved the data to formatted tables. Using this method you have more control over ill formatted data during the import process.