Text export differences between Access 95 and 2002
Posted on 2003-03-04
My company has been using Access 95 for several years. Our website is SQL server 7.0 driven, and is updated via Access CSV text export files which are uploaded to our web host and imported into SQL via an ASP invoked DTS script.
After upgrading to Access 2002, the DTS package now fails. Comparing Access 95 and 2002 export files side-by-side, the only differences I have been able to find are (a)Access 95 uses 2-digit years and (b)Access 2002 uses 4 digit years.
So my question is this: Are there any differences in the way 95 and 2002 export text files, and if so is there any way to force 2002 to export a file that is identicle to what Access 95 would export?