Create A foxpro table from ASP

[foxylady]

Does anyone know how to dynamically create a foxpro (.dbf) file from asp?

thanks

 

[jonscott8]

See thread184-193793 Jon Hawkins

 

[foxylady]

How do you put data in it from a recordset?

 

[jonscott8]

Set oConn = Server.CreateObject("ADODB.Connection&quot
Set oRS = Server.CreateObject("ADODB.Recordset&quot

oConn.Open "dsn=MyVFPDSN"
IF oConn.State <> 1 Then
'you got a problem, abort
END IF
oRS.Open &quot;MyTable&quot;, oConn, 1, 3, 2
IF oRS.State = 1 Then
oRS.AddNew
oRS.Fields(&quot;Field1&quot.Value = &quot;to&quot;
oRS.Fields(&quot;Field2&quot.Value = 2
oRS.Update
oRS.Close
END IF
oConn.Close

SET oConn = NOTHING
SET oRS = NOTHING

If I've misunderstood your question, my apologies - but you'll need to provide more description of what you are doing. Jon Hawkins

 

[foxylady]

I am trying to create a foxpro .dbf on a client machine and put data that I already have in a recordset to that table that i just created