Importing two digit year comma delimited dates


I'm using Pdox9, plus 1,2,3SP's, on WinXP prof.
The .csv dates are "04/01/07".
After importing, I get 4/1/1907 or 4/1/0007 (am importing from 2 files, one
having field names in first row of data).
I am importing using the Import Data feature and not the Text Expert feature
b/c the files have 125 fields.
Win XP short date format is 4/1/2007.
BDE 5.01 settings are: 4 digit yr = TRUE; LeadingZeroD = FALSE; LeadingZeroM
= FALSE; Mode = 0; Separator = /; YearBiased = TRUE.
Is there a way to get a 2007 year after importing?
Thanks.
.

Relevant Pages

  • Re: Importing Excel, more data type problems
    ... <MS ACCESS MVP> ... those first row values do not need to match the table's field names (but ... two problems importing this data. ... row of the Excel file, ...
    (microsoft.public.access.externaldata)
  • Text file, SAP and multi language support problems????
    ... I have been having difficulties for many months now when importing text data ... that is exported from SAP then FTP's from a UNIX server to my SQL server. ... contains 6 columns and the first row contains data only in the first 5 ...
    (microsoft.public.sqlserver.dts)
  • Please HELP! text import problems.
    ... I have been having difficulties for many months now when importing text data ... that is exported from SAP then FTP's from a UNIX server to my SQL server. ... contains 6 columns and the first row contains data only in the first 5 ...
    (microsoft.public.sqlserver.dts)
  • Importing Excel Worksheet
    ... I'm running Access 97 and I am importing data from Excel. ... I have tried formatting my spreadsheets as text - Access ... than entering text in the first row of the spreadsheets I ...
    (microsoft.public.access.externaldata)
  • Re: Please HELP! text import problems.
    ... > I have been having difficulties for many months now when importing text ... > that is exported from SAP then FTP's from a UNIX server to my SQL server. ... > contains 6 columns and the first row contains data only in the first 5 ...
    (microsoft.public.sqlserver.dts)