Importing csv file to SQL Server Management Studio - No tables available

Question

I am trying to import a csv file to insert data into an existing table on my database. I go through the wizard and when it comes to select source tables and views for the destination, there are none to choose from. It just thinks I am trying to create a new table.

Any suggestions? Thanks!

Answer 1

skip the wizard and use just BULK INSERT, here is an example:

http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/

Answer 2

Are you sure you selected the database to connect to properly? Are you sure you have the rights to insert into tables in that database?