Import binary flat file -
02-05-2004
, 09:10 AM
Hi all,
I have a number of binary flat file databases (fixed size records containing
strings, integers, dates, etc.) that are used in VB apps using type
structures, get, put, etc.
Does anyone know if it's possible to import these into a SQL table using DTS
?
If it involves writing my own drivers, do you know of a link to any examples
on the net ?
It's a pain exporting the data to a CSV file in VB because as there's no
eval() command you can't dynamically choose an existing type structure into
which the record can be loaded, forcing you to recompile the app for each
database. I guess it's time I learnt C#...
Any help would be greatly appreciated.
Dave Compton.
Autoclimate Ltd. |