You probably have to go and ask the person who created the file what program created
the file. Perhaps BCP in native mode?
Tibor Karaszi, SQL Server MVP
Neil's FAQ at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.
I was wondering if any of you out there has tried importing data from .dat
extension file type to SQL Server database. I understand that DTS wizard allows
importing data from different database sources as well as importing text file
into SQL Server db but somehow it doesn't recoginze the .dat extension file
format as it does not contain delimiter I suppose.
Was wondering if any of you has any ideas in going about to solve this problem.
I've included the file together with this posting.
Any suggestion will be appeciated. Thanks in advance.