Diane,
You will want an ADO recordset connecting via ODBC
Here's an example:
oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=c:\somepath\mySourceDbFolder;" & _
"Exclusive=No"
A great reference page:
http://www.able-consulting.com/ADO_Conn.htm
Does this help at all?
- IBIHAB
-----Original Message-----
From: Diane Schips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 10:00 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: OT? Two strange vb database how to questions
How do I get the data from FoxPro? I can't connect from within VB. Is
there a special reference or component I need to include? Is there any
documentation you can send me to?
Diane
-----Original Message-----
From: Roy, Siddarth S [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 10:56 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: OT? Two strange vb database how to questions
Well in that case u have do it this way
create a database in access of the same type (tables and coloumns ) and then
peridiocally take data from the foxpro using text files and muliple insert
in to access if it agrees to it
Hope this helps
Sid
-----Original Message-----
From: Diane Schips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:56 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: OT? Two strange vb database how to questions
I'm sorry, I didn't make myself clear. I need to do this programmatically,
from within VB (6.0 for now). It's part of a conversion program that will
be run periodically for our customers.
Diane
-----Original Message-----
From: Roy, Siddarth S [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:55 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: OT? Two strange vb database how to questions
If u want to import in access then go into file menu of the access database
then press get external data . u will get an option of import tables it will
ask databases in the last drop down select odbc then select fox pro which
ever data base u where using
i suppose when u querying the table u should be getting one value in the
coloumn
or multiple values take that value and run the function
thx
sid
-----Original Message-----
From: Diane Schips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:42 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] OT? Two strange vb database how to questions
I have two VB database questions. First, can anyone help me with reading a
.dbf database? It was created by a FoxPro program, and I want to import the
data into an Access database.
Second, I want to be able to read a function name from a database field,
then run that function. Its the 'run a function from a variable' part that
I'm having trouble with.
Diane
____ * The WDVL Discussion List from WDVL.COM * ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
____ * The WDVL Discussion List from WDVL.COM * ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
____ * The WDVL Discussion List from WDVL.COM * ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
____ * The WDVL Discussion List from WDVL.COM * ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
____ * The WDVL Discussion List from WDVL.COM * ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
