RE: Moving a text file to a physical file

Tom,

The SQL Server 2000 server and client install a wizard for importing and
exporting data to SQL Server.  This allows anything that ODBC can
connect to, including csv and other text files to be uploaded to SQL.
It also allows an easy connection to Excel and Access.  You can find it
on the Start menu under Microsoft SQL Server labeled "Import and Export
Data"

Jim 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
qsrvbas@xxxxxxxxxxxx
Sent: Monday, January 09, 2006 1:13 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Moving a text file to a physical file

midrange-l-request@xxxxxxxxxxxx wrote:

>   3. Moving a text file to a physical file (Brian Piotrowski)
>
>Is there an easy way to transfer delimited text from a text file that 
>resides on the AS/400 to a PF?  I have a semi-colon delimited file that

>is downloaded from an external source and placed on our AS/400.  Since 
>I'm having trouble moving this text file from the AS/400 to our SQL 
>server, I think the other way I can move the data is to transfer it to 
>an intermediary table on the AS/400 and then on to the MSSQL server.
>
>Is there a painless way of moving delimited text to a PF?


Brian:

I'm curious about whether or not a delimited file can be imported into
SQL Server at all. If you had a similar file on your SQL Server system,
would you be able to do it?

It seems odd that there is no MS support for this, so I'm surprised you
can't just use whatever MS provides and import through a network drive.

Tom Liotta

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com


__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at
http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp