OK to install Outlook 2003 client on an SQL Server 2005?

Hello,
I have an SQL 2005 server which is lightly used and I'd like to
install Outlook 2003 on it for a conversion utility which has nothing
to do with SQL.
Will installing Outlook cause problems for the SQL Server please?
Thanks,
- Alan.I've been using both of them on the same machine for a long time and I
haven't met a problem related to Outlook yet.
--
Ekrem Önsoy
"Alan" <bruguy@.gmail.com> wrote in message
news:1194340629.291591.23270@.k79g2000hse.googlegroups.com...
> Hello,
> I have an SQL 2005 server which is lightly used and I'd like to
> install Outlook 2003 on it for a conversion utility which has nothing
> to do with SQL.
> Will installing Outlook cause problems for the SQL Server please?
> Thanks,
> - Alan.
>|||That's good enough for me, thanks.
On Nov 6, 12:15 pm, Ekrem =D6nsoy <ek...@.btegitim.com> wrote:
> I've been using both of them on the same machine for a long time and I
> haven't met a problem related to Outlook yet.
> --
> Ekrem =D6nsoy
> "Alan" <bru...@.gmail.com> wrote in message
> news:1194340629.291591.23270@.k79g2000hse.googlegroups.com...
> > Hello,
> > I have an SQL 2005 server which is lightly used and I'd like to
> > install Outlook 2003 on it for a conversion utility which has nothing
> > to do with SQL.
> > Will installing Outlook cause problems for the SQL Server please?
> > Thanks,
> > - Alan.

ODBC Text file to SQL conversion

I have a large comma delimited text file (130K records) that I want to convert to an SQL data file. I want to use this data file as a datasource in a Visual Basic 2005 application.

Can I use the txt file directly?

If not, how can I convert/import the data into an SQL data file?

Thanks, Bob

Steve Kass has good info:
http://www.users.drew.edu/skass/sql/TextDriver.htm

You could also use openrowset() to query the data.

exec master..xp_cmdshell 'echo "this is a test" >> c:\temp\test.txt & echo
"this is a test2" >> c:\temp\test.txt'
go
select *
from OpenRowset('Microsoft.Jet.OLEDB.4.0',
'Text;Database=c:\temp\;HDR=NO',
'select * from test.txt')