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: 209831 # Views: 5 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 31, 2008 1:57:10 PM         
   


> >
> >
> > see Message ID: 32874 your answer is here.
> > regards
>
>
>
> 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

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