Copying VFP 8 tables to an Access MDB

I posted a message earlier concerning attaching to a VFP 8 directory as a database. I was able to do so but my ADO knowledge is limited.
I was able to open a dbf in ADO courtesy of Cindy


con.ConnectionString = _
"Data Source=" & dbfPath & ";" & _
"Provider=""VFPOLEDB.1"";"

con.CursorLocation = adUseClient
con.Mode = adModeRead
con.Open

'Get the names of the dbf's one at a time...................
dbfName = Dir(dbfPath & "\*.dbf")
While Not Len(dbfName) = 0

'Strip off the .DBF from the name...........
dbfName = Left(dbfName, InStr(dbfName, ".") - 1)


'This works..................I can read a field name and value
Set rst = con.Execute("SELECT * From " & dbfName)
If Not rst.BOF Then


'I would like to replicate the dbf in an MDB with the following but I get a syntax error.

con.Execute ("SELECT " & dbfName & ".* INTO " & dbfName & " " & _
"IN 'C:\TEMP\Temp\AccuPrint\vfl.mdb' " & _
"From " & dbfName & "")

This is a common SQL syntax but it fails in ADO.
Does this usually work in ADO?????

In news: 2F6AFA76-36F7-45B0-8F96-963C9A438C28 RemoveThis @microsoft.com,
RichG <anonymous RemoveThis @discussions.microsoft.com> wrote:
 > .....
 > con.ConnectionString = _
 > "Data Source=" & dbfPath & ";" & _
 > "Provider=""VFPOLEDB.1"";"
 > ........
 > 'I would like to replicate the dbf in an MDB with the following but I
 > get a syntax error.
 >
 > con.Execute ("SELECT " & dbfName & ".* INTO " &
 > dbfName & " " & _ "IN
 > 'C:\TEMP\Temp\AccuPrint\vfl.mdb' " & _ "From
 > " & dbfName & "")
 >
 > This is a common SQL syntax but it fails in ADO.
 > Does this usually work in ADO?????

Hi Rich,

You're using the VFP OLE DB provider to talk to VFP tables. You can only use
commands that the VFP OLE DB provider supports. While the VFP SQL Select
statement supports selecting into a FoxPro DBF it does not support selecting
into an Access MDB.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden RemoveThis @mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ -->