Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: khubaib khalid
  Where is khubaib khalid?
 HaroonAbad
 Pakistan
 khubaib khalid
 Tags
Subject: RE: dbf to access
Thread ID: 209795 Message ID: 209802 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 31, 2008 11:48:15 AM         
   


> I want to export data in access. How it will be done, I want to send selected dbf records in access.
> thanks

Basically you need to treat Access as a remote server. So you can either create an ODBC connection to the Access database and use SQL PassThrough or Remote View or CursorAdapter. Alternatively you can create an OLEDB connection to the Access database and use a CursorAdapter.

Either way you have to create a connection and then use SQL (either explicitly with SPT, or implicitly through the Remote View or CursorAdapter) to insert records.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA

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