Mounting a file as a database

  • Thread starter Thread starter Shaun Rigby
  • Start date Start date
S

Shaun Rigby

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
 
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! |
********************************************
 
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) said:
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! |
********************************************
Click to expand...

--
__________________________________________________________________________
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)
____________________________________________________________________________________________
 
Back
Top