Problem exporting over 255 characters in a field

[aswift]

Hi all,

I'm new here and attempted to search on this topic, but didn't seem to find anything pertaining to my problem...

I'm attempting to export a table using TransferSpreadsheet to an Excel 8-9 file, but one of the fields in my records is over 255 characters long. Importing it into Access works fine, but after I export it to the Excel file, it truncates the field to 255 characters. Is there a way around this?

I'm using Access 2000 and Excel 2000.

 

[dbc1]

The only way I have found to do this is to export the field contents in two halves and then put them back to gether with a mcro in Excel.

The following splits the data into two separate parts in a query prior to export, where CINATURE is the field name:

Expr1: Mid([CINATURE],1,250)

Expr2: Mid([CINATURE],251,250)

And the following puts it back together in the Excel macro:

=CONCATENATE(cell ref1,cellref2)

HTH

 

[dbc1]

The only way I have found to do this is to export the field contents in two halves and then put them back together with a macro in Excel.

The following splits the data into two separate parts in a query prior to export, where CINATURE is the field name:

Expr1: Mid([CINATURE],1,250)

Expr2: Mid([CINATURE],251,250)

And the following puts it back together in the Excel macro:

=CONCATENATE(cell ref1,cellref2)

HTH

 

[Brookelyn]

Transferdata using a macro

Not sure if this helps or not, but I have a program similar with the long fields. I made a macro...it opens the table of which i want to export and then i used the transferdata ability. On the transferdata there is a line that has a specification name. You can push F1 here to get help but i'll try to explain it. Click File, Get External Data, Import. On the bottom of this screen is a Advanced Button click it. Select whatever data it is you want to import. (This is mainly for show to get to this button you don't actually have to import.) Then tell it what your data is (columns, rows, data type) and click the Save as button. Whatever you saved it as should show in the drop down button of your macro line. When you save the specs, make sure to tell it which colums are memo's. That should make it export the data as a memo into excel and have all your letters. Good luck and I hope this helps!