Import ODBC Database using VBA

K

Khoa

Hi all,
I want to import a DBF file (which is created by Foxpro 2.6 for Dos that
have a MEMO field), via FoxPro ODBC, using VBA. For example: Import
C:\dbf1.DBF to Table1 in DB1.mdb by clicking Button1 on Form1. I hope this is
clear (since English isn't my First language).
Thanks in advance.
 
J

Jeff C

Lookup and read about the "Transferdatabase Method" and "Transferdatabase
Action".

You should not have any problems, place the resulting code in the "OnClick
Event" of your Button1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using ODBC import 1
Auto import DBF files 1
vba TO IMPORT FOXPRO dbfs or just replace table in 2003 2
Link/import/drop link DBF file via VBA 0
VBA ODBC Connection with 32bit and 64bit systems 2
Converting from ADP to MDB/ODBC linked tables 8
VBA to Import Visual FoxPro database (DBC) table (DBF) into Access 3
dynamic string connection sql import 1

Top