On Apr 23, 3:54=A0am, "myemail...@[EMAIL PROTECTED]
"
<myemail...@[EMAIL PROTECTED]
> wrote:
> 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!
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.
|
