I am using Microsoft Excel 2007 it is working only with DBF files, but not WK1, or WK2. All firstly it was not working but once I made the update from Microsoft web page it is working now.try to update your office from the internet
Member for
19 years 7 months
Member for19 years7 months
Submitted by Karim Mounir on Wed, 2007-10-31 07:47
First Access 2007 does import dbf files but not lotus files.
Second, you can still use access 2007 for P3 imports/exports.
"Export to dbf--> Open Access 2007-External Data-->Import to dbase-->select link to data source by creating a linked table--> Modify/update info-->Close-->Import back to P3.
(DBF file also gets updated).
Cheers
Datta
Member for
19 years 7 months
Member for19 years7 months
Submitted by Karim Mounir on Wed, 2007-10-31 04:53
Member for
19 years 6 monthsRE: Excel 2007
Hi Aytac
I am using Microsoft Excel 2007 it is working only with DBF files, but not WK1, or WK2. All firstly it was not working but once I made the update from Microsoft web page it is working now.try to update your office from the internet
Member for
19 years 7 monthsRE: Excel 2007
Right DATTATREYA, it can be done in Access 2007 not in Excel 2007.
Ive always used to do the import/export thing in P3 using Excel, thats way I never checked Access.
Thanks.
Member for
22 years 6 monthsRE: Excel 2007
Sorry,
First Access 2007 does import dbf files but not lotus files.
Second, you can still use access 2007 for P3 imports/exports.
"Export to dbf--> Open Access 2007-External Data-->Import to dbase-->select link to data source by creating a linked table--> Modify/update info-->Close-->Import back to P3.
(DBF file also gets updated).
Cheers
Datta
Member for
19 years 7 monthsRE: Excel 2007
I faced it.
Excel 2007 wont import wk1 or wks or dbf or prn files anymore.
U have to revert back to an earlier version of MS Excel.