I am having difficulty importing a comma delimited text file into a sql database. This is very easy for me to do in access. I have tried the "transfer text" method and it wont work in sql only access. I have had success with the "bcp" method, however I need to be able to massage the text coming into the database and bcp wont allow me to do that.
Any help would be greatly appreciated.
Thanks,
Steve
[email protected]