Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-27 : 09:06:05
|
| Kursat writes "Hi All,I use SQL Server 2000 database and I want to insert files with various extensions (.dat and .sr) and Excel files into my database using VBasic codes. I have read the article about "Using BULK INSERT to Load a Text File" but i need more help. Thanks alot" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-27 : 13:32:06
|
| Are you sure you want to store the actual files in SQL Server? As opposed to storing the UNC paths of their storage locations in your domain?Jonathan Boott, MCDBA |
 |
|
|
Kdemirez
Starting Member
1 Post |
Posted - 2002-06-29 : 06:29:53
|
quote:
Are you sure you want to store the actual files in SQL Server? As opposed to storing the UNC paths of their storage locations in your domain?Jonathan Boott, MCDBA
Hi Jonathan , I actullay store the each path of the files but for some reason I also need to store the file itself to SQL Server. So how to come over this problem!Thanks for your response Kursat Demirezen |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-07-01 : 14:23:10
|
quote:
I actullay store the each path of the files but for some reason I also need to store the file itself to SQL Server.
I'm not trying to be mean, but you don't know WHY you need to do this? I suggest you ask why because what you are asking to do is rather controversial in regard to whether it is "good practice". This is an offshoot of the debate about whether images should be stored in a database (see the SQLTeam FAQ) but this is a bit more complicated.Once you research whether you really want to do this, and if you decide that you do, check the entries in BOL for WRITETEXT. |
|
|
|
|
|
|
To insert OLE OBJECT into SQL Server