Hi Guys;

I have an Access Table (257 Columns) that I need to Export to an
Excel File.

I am using a Macro to create the Excel File.

Action = Output

Object Type =Table
Object Name = SchoolsExcl
Output Format = MicrosoftExcel(*.xls)
Output File = C:\TxTeachers\TexasHS.xls
Auto Start = No

Every Column comes accross except One.

The column that does not come accross completely is the largest field in my
table. 50 Characters long. It is a string.

Only about 7 to 8 characters come accross. If the field contains Anthony
Independent School District in my Access Table, the Excel file only shows the
Word District. The characters that come accross are always the last 7 or 8
(or the right side of the field).

The rest of the columns come accross fine.

Anyone have an idea as to how I can get this to work?

Thanks in Advance

Toni.

An .xls file cannot have more than 255 columns, so I'm surprised that you
get any columns at all.

An ACCESS table with 257 fields "screams" that the database is not
normalized. Most ACCESS tables will have less than 30 fields when a database
is properly normalized.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Antonette" <(E-Mail Removed)> wrote in message
news:BC3D61A4-9C67-4AD3-B758-(E-Mail Removed)...
> Hi Guys;
>
> I have an Access Table (257 Columns) that I need to Export to an
> Excel File.
>
> I am using a Macro to create the Excel File.
>
> Action = Output
>
> Object Type =Table
> Object Name = SchoolsExcl
> Output Format = MicrosoftExcel(*.xls)
> Output File = C:\TxTeachers\TexasHS.xls
> Auto Start = No
>
> Every Column comes accross except One.
>
> The column that does not come accross completely is the largest field in
> my
> table. 50 Characters long. It is a string.
>
> Only about 7 to 8 characters come accross. If the field contains Anthony
> Independent School District in my Access Table, the Excel file only shows
> the
> Word District. The characters that come accross are always the last 7 or
> 8
> (or the right side of the field).
>
> The rest of the columns come accross fine.
>
> Anyone have an idea as to how I can get this to work?
>
> Thanks in Advance
>
> Toni.
>
>
>

Ken;

I am sorry, I counted wrong! It is 127 Columns!

Still the same problem.

Sorry for misleading you guys.

Thanks

Toni

"Ken Snell" wrote:

> An .xls file cannot have more than 255 columns, so I'm surprised that you
> get any columns at all.
>
> An ACCESS table with 257 fields "screams" that the database is not
> normalized. Most ACCESS tables will have less than 30 fields when a database
> is properly normalized.
>
> --
>
> Ken Snell
> http://www.accessmvp.com/KDSnell/
>
>
> "Antonette" <(E-Mail Removed)> wrote in message
> news:BC3D61A4-9C67-4AD3-B758-(E-Mail Removed)...
> > Hi Guys;
> >
> > I have an Access Table (257 Columns) that I need to Export to an
> > Excel File.
> >
> > I am using a Macro to create the Excel File.
> >
> > Action = Output
> >
> > Object Type =Table
> > Object Name = SchoolsExcl
> > Output Format = MicrosoftExcel(*.xls)
> > Output File = C:\TxTeachers\TexasHS.xls
> > Auto Start = No
> >
> > Every Column comes accross except One.
> >
> > The column that does not come accross completely is the largest field in
> > my
> > table. 50 Characters long. It is a string.
> >
> > Only about 7 to 8 characters come accross. If the field contains Anthony
> > Independent School District in my Access Table, the Excel file only shows
> > the
> > Word District. The characters that come accross are always the last 7 or
> > 8
> > (or the right side of the field).
> >
> > The rest of the columns come accross fine.
> >
> > Anyone have an idea as to how I can get this to work?
> >
> > Thanks in Advance
> >
> > Toni.
> >
> >
> >
>
>
>

Try using TransferSpreadsheet macro action instead of OutputTo action.

And, again, 127 fields in a single table still strongly suggests that your
table and data are not normalized.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Antonette" <(E-Mail Removed)> wrote in message
news:E9F683BE-E797-4921-9241-(E-Mail Removed)...
> Ken;
>
> I am sorry, I counted wrong! It is 127 Columns!
>
> Still the same problem.
>
> Sorry for misleading you guys.
>
> Thanks
>
> Toni
>
> "Ken Snell" wrote:
>
>> An .xls file cannot have more than 255 columns, so I'm surprised that you
>> get any columns at all.
>>
>> An ACCESS table with 257 fields "screams" that the database is not
>> normalized. Most ACCESS tables will have less than 30 fields when a
>> database
>> is properly normalized.
>>
>> --
>>
>> Ken Snell
>> http://www.accessmvp.com/KDSnell/
>>
>>
>> "Antonette" <(E-Mail Removed)> wrote in message
>> news:BC3D61A4-9C67-4AD3-B758-(E-Mail Removed)...
>> > Hi Guys;
>> >
>> > I have an Access Table (257 Columns) that I need to Export to
>> > an
>> > Excel File.
>> >
>> > I am using a Macro to create the Excel File.
>> >
>> > Action = Output
>> >
>> > Object Type =Table
>> > Object Name = SchoolsExcl
>> > Output Format = MicrosoftExcel(*.xls)
>> > Output File = C:\TxTeachers\TexasHS.xls
>> > Auto Start = No
>> >
>> > Every Column comes accross except One.
>> >
>> > The column that does not come accross completely is the largest field
>> > in
>> > my
>> > table. 50 Characters long. It is a string.
>> >
>> > Only about 7 to 8 characters come accross. If the field contains
>> > Anthony
>> > Independent School District in my Access Table, the Excel file only
>> > shows
>> > the
>> > Word District. The characters that come accross are always the last 7
>> > or
>> > 8
>> > (or the right side of the field).
>> >
>> > The rest of the columns come accross fine.
>> >
>> > Anyone have an idea as to how I can get this to work?
>> >
>> > Thanks in Advance
>> >
>> > Toni.
>> >
>> >
>> >
>>
>>
>>