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
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
Microsoft AccessMicrosoft ExcelMicrosoft Office
Last Comment
Gustav Brock
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Solutions provided.
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.