Inserting flat files into a table

[HobbyMan]

Is it possible to get a file inserted into
a table? If so, how?

Or would it be better to store the path to
the file into the table?

We are trying to come up with a way to allow customers
to upload flat files to our support site. The flat
files will more than likely only contain text
(parameter files, config files, data files, etc.).

Any other suggestions? [sig][/sig]

 

[Atavistic]

BCP and DTS will do this for you. [sig][/sig]

 

[HobbyMan]

Sorry, I am new to Sql Server world.

What do the acronyms BCP and DTS mean? [sig][/sig]

 

[MichaelRed]

Hobby,

I would NEVER provide a customer user with the capability of entering large ammountsd of data in a database. This would be even more of a problem for me when the information could be in a variety of formats.

I would not even be very comfortable with their directly uploading files to my site/server I would prefer the information be provided in the form of attachments to e-mail with specific information in the subject line, to identify the file type/format ...

Ms. Access can read standard e-mail files, determine the subject line, parse the (attached) file and do a great deal of processing, based on your needs. This also permits the e-mail and attachment(s) to be reviewed by Virus software, and other filters you set up.

Altogether much 'safer'

[sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]

 

[Atavistic]

BCP - Bulk Copy
DTS - Data transformation Services

If you look them up in the help file it will explain how to use each of them. [sig][/sig]