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
lgreallyAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.