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: 209860 # Views: 4 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 31, 2008 6:12:13 PM         
   


> >
> >
> > Yes its a problem.I even convert a table to fox2x by (copy mytable to ...fox2x)
> > but that retrieve error.Maybe Rubinov(the code author) have a solution ?
> > Even i dont see any foxpro type in import of msaccess(i see dbase,excel,...).I try with dbase it returns error also.
> > then use my code below.
> > I convert my table to excel and import it in access easily with a new command.
> >
> > *Author Yousfi Benameur   dec30,2008
> > if file("c:\asup.mdb")
> > dele file c:\asup.mdb
> > endi
> > 
> > use getfile('dbf')
> > copy to c:\myExcel.xls xl5
> > use
> > 
> > 
> > oAccess = CreateObject("Access.Application")
> > *create new MDB file
> > oAccess.NewCurrentdatabase("c:\asup.mdb")
> > 
> > #define acimport 0
> > oAccess.DoCmd.TransferSpreadsheet(acImport, 5,"mymdb","C:\myexcel.xls", .t.)
> > 
> > oAccess.quit
> > oAccess=.null.
> > release oAccess
> > 
> > &&show
> > 
> > DECLARE INTEGER ShellExecute IN shell32.dll ; 
> >   INTEGER hndWin, STRING cAction, STRING cFileName, ; 
> >   STRING cParams, STRING cDir, INTEGER nShowWin
> > 
> > aa="c:\asup.mdb"
> > ShellExecute(0,"open",aa,"","",1)
> > 
> > 
> > 
> > 
> > 

> > regards
>
> yousfi can you tell me what is "xl5" copy to c:\myExcel.xls xl5

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 !

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