Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot, bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon

Links

XODOX
Impressum

#1: exporting a table with long field names to Access

Posted on 2008-04-23 10:54:24 by myemail.an

Hi all,

I need to export a table from Ms Sql to Access. However, dts import/
export gives me an error because the field names are too long. Is
there a quick way to trim the names of all fields to the 64 characters
allowed by Access? Or is there a better alternative?

Thanks!

Report this message

#2: Re: exporting a table with long field names to Access

Posted on 2008-04-23 15:56:14 by Tom van Stiphout

On Wed, 23 Apr 2008 01:54:24 -0700 (PDT), "myemail.an@googlemail.com"
<myemail.an@googlemail.com> wrote:

You could create a view that returns the data from that table, and
alias each column name:
create view dbo.ExportXyzTable as
select RidiculouslyLongColumnName1 as ShortCol1,
RidiculouslyLongColumnName2 as ShortCol2,
-- etc.
from XyzTable

Then use that view for exporting.

-Tom.


>Hi all,
>
>I need to export a table from Ms Sql to Access. However, dts import/
>export gives me an error because the field names are too long. Is
>there a quick way to trim the names of all fields to the 64 characters
>allowed by Access? Or is there a better alternative?
>
>Thanks!

Report this message

#3: Re: exporting a table with long field names to Access

Posted on 2008-04-24 04:48:24 by Sam

On Apr 23, 3:54=A0am, "myemail...@googlemail.com"
<myemail...@googlemail.com> wrote:
> Hi all,
>
> I need to export a table from Ms Sql to Access. However, dts import/
> export gives me an error because the field names are too long. Is
> there a quick way to trim the names of all fields to the 64 characters
> allowed by Access? Or is there a better alternative?
>
> Thanks!

Ok, first off, someone correct me if I'm wrong, but this should
work...

Connect to the SQL server from access (linked tables) through odbc.

odbc will shorten the file names then copy the data into a new local
table in access thereby trimming the Column names down to 64 chars.

Report this message