Text export differences between Access 95 and 2002

Posted on 2003-03-04
Medium Priority
Last Modified: 2012-06-27
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?
Question by:justin_draper
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Accepted Solution

SmallDeath earned 225 total points
ID: 8067016
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...

Author Comment

ID: 8083527
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.

Author Comment

ID: 8083563
I found an option in the export specifications that allows you to specify 2 or 4 digit years.  Right where it should be! :|

Author Comment

ID: 8083597
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.

Featured Post

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question