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


> >
> >
> >
> > thanks Yousfi, It is locking , for foxpro 3 not for vfp9.error, please give me detail
>
>
> 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

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