Exporting data from Sql Server 6.5

Article View: dc.test

Article #1852

#1852

From: David Murphy
Date: Mon, 21 Jun 1999 00:00

11 lines
1027 bytes

Because of new firewall requirements at work, my group of VB/Access
developers finds we need to have data exported from 6.5 and then
sneaker-netted. The mighty network gods who control the SQL server have
managed to export an MDB file but say they can't have a MMDDYYYY name.
The leading zeroes get dropped. I would like to be able to help them on
what we need but haven't a clue. How can this be done? I really don't
know if they are using BCP, a 3rd part tool, or what as they won't stoop
to tell me.

Thanks,
----dave

Technical Details

Message-ID: <376E6E7D.A7F6D29E@his.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10da22,7b6f0622d3c31b30,start
X-Google-Attributes: gid10da22,public
From: David Murphy <djmurphy@his.com>
Subject: Exporting data from Sql Server 6.5
Date: 1999/06/21
Message-ID: <376E6E7D.A7F6D29E@his.com>
X-Deja-AN: 492161571
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Authenticated-User: djmurphy
Organization: Maybe someday
MIME-Version: 1.0
Newsgroups: dc.test