I have a fixed-width file over here. Is there a good way to import it with ODBC (want to make a Remote View on it), or should I bite the bullet and import it SDF?


DBQ=\\server\C$;DefaultDir=\\server\C$;Driver={Microsoft Text Driver (*.txt; .csv)};DriverId=27;Extensions=*;FIL=text;FILEDSN=c:\a.txt.dsn;MaxBufferSize=2048;MaxScanRows=25;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;Use

That's not working for view creation.

What's a good programmatic way to import SDF?

Thanks.