Prev: Job ends successfully even when it's not true
Next: using LEN to find a first word greater than 17
From: myemail.an on 23 Apr 2008 04:54
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!
From: Tom van Stiphout on 23 Apr 2008 09:56
On Wed, 23 Apr 2008 01:54:24 -0700 (PDT), "myemail.an(a)googlemail.com"
<myemail.an(a)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!
From: sam on 23 Apr 2008 22:48
On Apr 23, 3:54 am, "myemail...(a)googlemail.com"
<myemail...(a)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.
 | 
Pages: 1
Prev: Job ends successfully even when it's not true
Next: using LEN to find a first word greater than 17