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

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

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

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

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

Here it looks like





Snap6.bmp

if you open the file you can see how it looks like

Thanks for your quick response