Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Sep 20, 2011 08:44 PM by seamus1982
Sep 20, 2011 02:29 PM|LINK
Databases are not my thing. I am trying to do a bulk insert so I tried doing it with a query
BULK INSERT dbo.make_model
From 'c:\Database Backup\tempDataLoad.csv'
FIELDTERMINATOR = ' , ',
ROWTERMINATOR = '\n'
but I get the response cannot find make_model table. I don't know where I am going wrong any help would be appreciated.
If I could do it in a stored procedure or something. Is there a way of me specifying the database. I tried putting the database before the table name with a dot in front.
Sep 20, 2011 02:54 PM|LINK
If you're saying you tried:
BULK INSERT databasename.dbo.make_model
it should have worked. If it doesn't, then the table must not exist, or you may be executing in a context that does not have permission to do bulk inserts to it.
Sep 20, 2011 08:44 PM|LINK
Its something to do with me creating the database in visual studio rather than in management studio.