On Wed, 23 Apr 2008 01:54:24 -0700 (PDT), "my********@googlemail.com"
<my********@googlemail.comwrote:
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!