| BOLAJIKAMORU 2002-04-29, 7:37 am |
| I am trying to import data from a flat file into an sql database. I used the DTS import but most of the data were truncated as each source record was converted into just a single data column of datatype varchar(128).
Although the source file has .dbf as file extension but records are not segmented into columns/fields. I used Foxpro as the OLE DB provider. Each source record is a stream of data and not classified into columns.
I would like to export the data into a text file so that it could be formatted into columns by using the substring function and delimeter. After which, it will be imported into an sql DB.
Any suggestions pls. |