Re: ex****ting a table with long field names to Access

On Wed, 23 Apr 2008 01:54:24 -0700 (PDT), "myemail.an@[EMAIL PROTECTED]
"
<myemail.an@[EMAIL PROTECTED]
> wrote:

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

Then use that view for ex****ting.

-Tom.


>Hi all,
>
>I need to ex****t a table from Ms Sql to Access. However, dts im****t/
>ex****t 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!