William
Mon Jul 21 11:53:47 CDT 2008
I'm with Mr. Beamer. While you can open a CSV as a file (using JET), I would
not recommend this approach as there are a host of issues that will plague
you like those ants that keep getting into the kitchen. I would use
SqlBulkCopy (or SSIS) to import the data into SQL Server so it can be
properly processed, validated and can easily participate in JOINs etc.
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:#aQGAC06IHA.3512@TK2MSFTNGP02.phx.gbl...
> There are a couple of different things I can think of here:
>
> 1. Mounting files for a web site
> 2. Mounting files to move them to another location
>
> The first is as simple as a connection string, in ASP.NET. The second is a
> very low level DBA function. Neither mount a CSV file, however.
>
> You can set up an SSIS (SQL Server Integration Services) application to
> suck in files from a specific directory and use it on your CSV files. It
> can be pulled to a temp table, for safety, and then worked on.
>
> I know of no way to simply mount a CSV as a database file and then use it.
> If you find something, please post back.
>
> --
> Gregory A. Beamer
> MVP, MCP: +I, SE, SD, DBA
>
> Subscribe to my blog
>
http://gregorybeamer.spaces.live.com/lists/feed.rss
>
> or just read it:
>
http://gregorybeamer.spaces.live.com/
>
> ********************************************
> | Think outside the box! |
> ********************************************
> "Shaun Rigby" <shaun.rigby@NoSpam.ntlworldd.com> wrote in message
> news:tSrgk.5467$EX5.2130@newsfe05.ams2...
>> Hi Guys,
>>
>> I am trying to create a Windows Service to update 14000+ products on my
>> website every 30 minutes
>>
>> I download CSV pricelists from my suppliers during this process but I
>> found an article on the internet a while ago, but I cant seem to find it
>> any more about mounting a file as a database using ADO
>>
>> Any ideas how I would do this? or where the website is?
>>
>> TIA
>
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________