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: 537
  • Last Modified:

import csv file into sql 8 express

Hi,

Im using sql server 8 express and cannot see the csv/xls option in the import/export wizard.
Any help I see involves writing queries, is there a simple way to import like the full version where you can browse to xls/txt/csv files?

Thanks
0
lgreally
Asked:
lgreally
1 Solution
 
Ephraim WangoyaCommented:

You use the Flat File Source, thats for all delimited files CSV, TXT)
ImportCSV.png
0
 
lgreallyAuthor Commented:
Thanks

I used the xls option and it worked well
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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