Access Table to Excel Spreadsheet

  • Thread starter Thread starter Antonette
  • Start date Start date
A

Antonette

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;

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

Still the same problem.

Sorry for misleading you guys.

Thanks

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.
 
Back
Top