• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

Text export differences between Access 95 and 2002

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?
0
justin_draper
Asked:
justin_draper
  • 3
1 Solution
 
SmallDeathCommented:
From my experiences with access... data is arranged differently on 2k2 than the earlier versions.  BUT!  access does allow for backward compatibility.  there is an option (under the file menu, i think) that allows you to save the file as a certain type.

sorry i couldn't be more of help...
0
 
justin_draperAuthor Commented:
I was unable to find any options in Access 2002 for backward compatibility.
I need to find some way to force 2-digit years in the text file export.
0
 
justin_draperAuthor Commented:
I found an option in the export specifications that allows you to specify 2 or 4 digit years.  Right where it should be! :|
0
 
justin_draperAuthor Commented:
SmallDeath - Your answer wasn't exactly correct but it did cause me to look around and find the answer myself.  Since no one else took the time to post you get the points.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now