Re: Access Import

#1

If you import the contents of the XL file into a table that has a
column defined with the newid() function, SQL Server will generate a
new guid value for you. See the NEWID topic in SQL Server Books Online
for more information.

--Mary

On Wed, 15 Sep 2004 07:47:09 -0700, "Jim Heavey"
<JimHeavey (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have used DTS a couple of time to take a SQL table and export it to an
Access File. Now I want to take an Excel file and import it into my SQL
table. This SQL table is keyed by a GUID and to my knowledge there is no way
to easily generate these in Excel.

So being pretty novice at the DTS process, how can I import an Excell file
into a SQL table and at the same time generate the GUID? I presume DTS is
the place to do this at..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Access Import

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Access Import - 09-17-2004 , 02:59 PM