May 22nd, 2000, 09:50 PM
Hi,
HelenZak was kind enough to point me in the right
direction for the problem that I am having, which is
to access a non-MDB table using Jet - this comes from
the problem that I have had for quite awhile to overcome
deficiencies with the FoxPro drivers.
I was pointed to the INSERT INTO clause. I believe I
have it set up, but when I run it, I get a "Syntax Error In INSERT INTO Statement" error. I am connecting use Jet
3.51.3328 and my tables are FoxPro 3.0 tables. I have
the test.mdb database created, and my test.dbf file is
also in C:\Data as shown below. I have tried this both
with and without test.dbf linked in to test.mdb. I can
open test.dbf fine as a linked table directly in the mdb.
ConnStr = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=C:\Data\test.mdb;"
conn.Open ConnStr
INSERT INTO test IN "C:\Data" "FoxPro 3.0;" (key, test) VALUES (1, 'test');
Can someone please point out my obtuseness?
Thanks,
Erik
HelenZak was kind enough to point me in the right
direction for the problem that I am having, which is
to access a non-MDB table using Jet - this comes from
the problem that I have had for quite awhile to overcome
deficiencies with the FoxPro drivers.
I was pointed to the INSERT INTO clause. I believe I
have it set up, but when I run it, I get a "Syntax Error In INSERT INTO Statement" error. I am connecting use Jet
3.51.3328 and my tables are FoxPro 3.0 tables. I have
the test.mdb database created, and my test.dbf file is
also in C:\Data as shown below. I have tried this both
with and without test.dbf linked in to test.mdb. I can
open test.dbf fine as a linked table directly in the mdb.
ConnStr = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=C:\Data\test.mdb;"
conn.Open ConnStr
INSERT INTO test IN "C:\Data" "FoxPro 3.0;" (key, test) VALUES (1, 'test');
Can someone please point out my obtuseness?
Thanks,
Erik