Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yousfi Benameur
  Where is Yousfi Benameur?
 El Bayadh
 Algeria
 Yousfi Benameur
 To: khubaib khalid
  Where is khubaib khalid?
 HaroonAbad
 Pakistan
 khubaib khalid
 Tags
Subject: RE: dbf to access
Thread ID: 209795 Message ID: 209866 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 31, 2008 6:32:01 PM         
   


> >
> > XL5
> > Creates a Microsoft Excel version 5.0 workbook file. Each field from the currently selected table becomes a column in the spreadsheet, and each record becomes a row. If you do not include a file extension, an .xls extension is assigned to the new workbook.
> >
> >
> >
> > XLS
> > Creates a Microsoft Excel version 2.0 worksheet file. Each field from the currently selected table becomes a column in the spreadsheet, and each record becomes a row. If you do not include a file extension, an .xls extension is assigned to the new worksheet.
> >
> >
> > Regards and happy new year !
>
>
> thanks i was coping recods like this, Its work more perfect than copy u tel me, When i try to change formate error
> Copy to (sys(5)+alltrim(sys(2003)))+'\result.xls' type xls

you do not need to include the TYPE keyword (optionally).
I tell you I never work with access
I try with xls it returns error.maybe Access version dont accept this format (type xls).
xl5 type works well.
Regards

ENTIRE THREAD

dbf to access Posted by khubaib khalid @ 12/31/2008 11:06:45 AM
RE: dbf to access Posted by Stefan Wuebbe @ 12/31/2008 11:36:03 AM
RE: dbf to access Posted by Andy Kramek @ 12/31/2008 11:48:15 AM
RE: dbf to access Posted by Yousfi Benameur @ 12/31/2008 11:54:54 AM
RE: dbf to access Posted by khubaib khalid @ 12/31/2008 12:11:16 PM
RE: dbf to access Posted by M. Akram Bhatti @ 12/31/2008 1:46:19 PM
RE: dbf to access Posted by Yousfi Benameur @ 12/31/2008 1:57:10 PM
RE: dbf to access Posted by khubaib khalid @ 12/31/2008 5:21:24 PM
RE: dbf to access Posted by khubaib khalid @ 12/31/2008 6:07:24 PM
RE: dbf to access Posted by Yousfi Benameur @ 12/31/2008 6:12:13 PM
RE: dbf to access Posted by khubaib khalid @ 12/31/2008 6:16:30 PM
RE: dbf to access Posted by Yousfi Benameur @ 12/31/2008 6:32:01 PM
RE: dbf to access Posted by M. Akram Bhatti @ 12/31/2008 12:43:26 PM
RE: dbf to access Posted by khubaib khalid @ 12/31/2008 12:49:52 PM
RE: dbf to access Posted by Biju Thomas @ 1/1/2009 5:37:48 AM
RE: dbf to access Posted by khubaib khalid @ 1/1/2009 3:15:17 PM
RE: dbf to access Posted by Anders Altberg @ 1/2/2009 2:05:56 AM
RE: dbf to access Posted by khubaib khalid @ 1/2/2009 5:18:40 PM
RE: dbf to access Posted by Anders Altberg @ 1/2/2009 6:16:08 PM