How to transform data from .txt file to SQL server tables

easy_life
easy_life used Ask the Experts™
on
Hi I have  flat file and I would like to export data from this file to SQL server tables
Snap2.bmp
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Right click on the database, choose TASKS and then IMPORT DATA

It looks like thats what you're doing.  Are you running into a problem?  If so please describe it

Commented:
You could also use SQL BULK INSERT command.
http://msdn.microsoft.com/en-us/library/ms188365.aspx

Author

Commented:
it throws an error message and you can find in the attachment,
whats my question is which options I have to choose from the above in order to expoert successfully.
i.e  Delimited or Fixed.
File Type , Row Delimiter, Text Qualifier
Thanks

Snap4.bmp
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

If you open the file in a text editor is there a verticle bar there or is it a tab?

Author

Commented:
Here it looks like





Snap6.bmp

Author

Commented:
if you open the file you can see how it looks like
try selecting {CR}{LF} as the row delimiter

Author

Commented:
Thanks for your quick response

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial