Using Bulk Copy Program / Linked Server to transfer Excel-VBA file into SQL server -


i have excel-vba file 15000 rows , 4 columns. need insert 2 of columns microsoft sql management studio. have been looking @ youtube tutorials how new got lost.

i have tried convert file .text file insert sql server. tried linked server method did not seem work -- if have advice on way make work instead, welcome well!

code in ssms:

create table exporttool(tooling_sheet carchar, tools varchar)  insert exporttool values "insert range here...  select * exporttool 

** edited code in ssms: **

create table importtool(tooling_sheet carchar, tools varchar)  bulk insert dbo.importtool openrowset('microsoft.jet.oledb.4.0', 'j:\test-tds\tools.text');     (     /* insert range here */     )  select * importtool 

using cmd:

dev.dbo.exporttool out j:\test-tds\tools.txt -t -c 

enter: gave output 0 rows copied

dev.dbo.exporttool out j:\test-tds\tools.text -t -c 

enter: gave output :

error = unable open bcp host data-file 

am typing cmd incorrectly not copying files? , how alter code in ssms information file. cannot find going wrong.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

Kivy: Swiping (Carousel & ScreenManager) -