>Hi Cetin,
>
>I have utilized the code that you pointed me to and was successful in creating the VFP tables from the Access database.
>
>I do, however, have a couple of questions regarding the results...
>
>Why would some of the fields come over as MEMO?
>
>and
>
>Is there a way to not have .NULL. values?
>
>TIA
>Vince
With ODBC UseMemoSize controls the maximum length of char fields (default 255, 1-255). ie:
lnHandle=SQLStringConnect(...)
CURSORSETPROP('UseMemoSize',255,0)
SQLExec(m.lnHandle,...,...)
Set null off
would help if explicitly .null. values are not in data.
You might try to workaround getting via ADO instead. ie:
LOCAL oRs as adodb.recordset
oCon = createobject("AdoDb.Connection")
oCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..."
oCon.Open
oRS = oCon.Execute(...)
xDOM = NEWOBJECT('MSXML.DOMDocument')
oRS.Save(xdom, 1)
oRS.Close
oCon.close
XMLTOCURSOR(xdom.xml, "MyCursorName", 1028)
SELECT MyCursorName
BROWSE
Cetin