Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

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

Hi I have  flat file and I would like to export data from this file to SQL server tables
Snap2.bmp
0
easy_life
Asked:
easy_life
  • 4
  • 3
1 Solution
 
matty1stopCommented:
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
0
 
Louis01Commented:
You could also use SQL BULK INSERT command.
http://msdn.microsoft.com/en-us/library/ms188365.aspx
0
 
easy_lifeAuthor 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
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
matty1stopCommented:
If you open the file in a text editor is there a verticle bar there or is it a tab?
0
 
easy_lifeAuthor Commented:
Here it looks like





Snap6.bmp
0
 
easy_lifeAuthor Commented:
if you open the file you can see how it looks like
0
 
matty1stopCommented:
try selecting {CR}{LF} as the row delimiter
0
 
easy_lifeAuthor Commented:
Thanks for your quick response
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now