>I am using SqlExex and M/S Excel Driver to Import Excel Files into a DBF
>SqlExec(MyHandel,MyConnection, MyCursor)
>
>All working fine, and Importing data, however, Memo Fields are being created utomatically for Text Info, whereas I would prefer Chracter fields
>Is there a way of specifying that I want Character fields (Even c(100) for every field)
>
>Tia
>Gerard
Use CAs instead of SQLEXEC() and use their schema to set type and length of the fields.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.