Error exporting long file name using transferspreadsheet

[Hernan Castro]

Hi group,

Yesterday I posted my recently discover problem...
I used to be able to export files using the
transferspreadsheet command to long destination paths...

But recently access 97 became unable to do it...

it is very easy to reproduce the problem...

let's export the table Customers to this
destination "C:\New Folder to generate error\new folder to
generate error"

docmd.TransferSpreadsheet acExport,
acSpreadsheetTypeExcel97, "Customers","C:\New Folder to
generate error\new folder to generate error\Customers.xls"

Then you get the Run-Time Error '3027'

I found the Microsoft Knowledge Base Article - 168870
where it says access is unable to export text files with
file names longer than 60 characters.. could this be the
same problem?

Why was I able to export to longer files previously...?

One more thing even more interesting.. if the file
Customers.xls already exists in the destination folder..
then access is able to overwrite it!!

Can figure it out!!

Thanks for your ideas!!

Hernan