Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Required Excel 8.0 in Data Export

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-10 : 09:41:25
Muzaffar writes "Hi, i am trying to export the data from Accpac software which is using SQL, but while eporting its not showing Excel 8.0, its showing only upto Excel 2.0, 3.0, 4.0. Please help if anybody knows how to get it as i have unistalled and reinstalled the complete Office2003 but still the same problem.
Thanks
Muzaffar."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-02-10 : 09:44:24
AccPac is basically crap, and does not have particularly advanced import/export utilities. However, Office 2003 should be able to import Excel 4.0 with no problem, and you can export to Lotus 1-2-3 (WKS), Quattro, or DIF formats if AccPac supports them. Lastly, CSV or tab-delimted text will also work well. Excel can read all of those.
Go to Top of Page
   

- Advertisement -