Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > exporting a tab...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 10991 of 11205
Post > Topic >>

exporting a table with long field names to Access

by "myemail.an@[EMAIL PROTECTED] " <myemail.an@[EMAIL PROTECTED] > Apr 23, 2008 at 01:54 AM

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!




 3 Posts in Topic:
exporting a table with long field names to Access
"myemail.an@[EMAIL P  2008-04-23 01:54:24 
Re: exporting a table with long field names to Access
Tom van Stiphout <no.s  2008-04-23 06:56:14 
Re: exporting a table with long field names to Access
"sam@[EMAIL PROTECTE  2008-04-23 19:48:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sat Jul 5 5:03:58 CDT 2008.