Importing csv file
-
I save a results set to .csv instead of excel because the results were too large for excel.
Now, I would like to import the table to my database but do not know how using DTS. I've imported several Excel spreadsheets using DTS, can i not do the same with a .csv file?
-
You need 1 of these (called "Text File (Source)" in the DTS Connections toolbox) as the data source:
[Picture removed, it was a local filesystem link]
Then set the properties to comma delimied.
-
hm...the picture did not seem to display.
-
Put your mouse cursor on top of the icon, a hint will display. It's one of the connection icons that looks like a printed page.
-
Try this picture !
-
-
Create a new package. Add the text file source from either the connection toolbox, or the connection menu:
-
Testing....do you see the picture below? I used the "Image Insert" option at the top.
Signature is NULL
-
Heh, good catch. The images get inserted with file: tags pointing to the local disk, so only the author of the reply can see them. Guess you have to host the image on a webserver somewhere and insert from the http: URL.
-
Yeah, that's what I figured...one of those hard-to-catch bugs (somebody should tell Steve or Andy, but they probably can't fix the office plugin). can you see this?
Signature is NULL
-
If you look at this site it should get you well on your way!
http://www.sqldts.com/default.aspx?101
Darrell
-
yes...and might i add....nice picture!!
-
thanks! Fractals rock.
Signature is NULL
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply