Link to home
Start Free TrialLog in
Avatar of Issa S.
Issa S.

asked on

I need to export an Access file from Access DB  to  Excel in Format 5.0 /95.

Hi All,,

I need to export an Access file from Access DB  to  Excel in Format 5.0 /95.
This results in Exported number of records nearly 16000   while the Access file is around 34000 Records.
Due to the need for Importing this data into another Old type DB (FoxPro), the 5.0/95 is needed.

I have no problem in Exporting much larger files (>800,000Recs) from other Access files

Help Please
SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Issa S.
Issa S.

ASKER

Hi   Dale,,,

This will be a huge effort but will not an issue after passing the interim period of Parallel Run as we are in the middle of migrating to the New Access system.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'm a bit confused by the numbers of records in your initial description, as well as the need to use Excel as the export target.  Also, if you're moving the data to another Access system, what is the purpose of the FoxPro DBF?

In any case, FoxPro can indeed import records from a CSV, so if you can export your Access to that format you won't need Excel to get it into the FoxPro file.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Solutions provided.