var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Importing a text file
Hi all I need to import a text file into sql server 2014 I was going to use the import wizard but I'm not sure how to separate the columns. In the each section/column is separated by ###, !!!!, @@@@@ and &&&
I'm not sure to separate those into columns, can anyone help please
!!!OXIDE REPLACEMENT@@@MICROETCH###Active Oxygen Content 748$$$ANAL%%%0.8000 g/l^^^15.92&&&H.HalperTTT201507010626???INSPECOoCN/A
was going to do a bulk insert but I keep getting this message Msg 208, Level 16, State 82, Line 3
FROM 'C:\Users\Administrator\Documents\201507.txt' --location with filename
FIELDTERMINATOR = '@@@ ,%%%, &&&, ???',
ROWTERMINATOR = '\n'
Invalid object name 'LabWizardData'.
Last edited by desireemm; 07-11-15 at
Edit the text file...make the delimiters "," the way EVERYONE does it.
Yes I figured it out I edited the text I made all the special characters commas with find and replace all and now I'm fine