Forum Discussion

Brass Contributor

Sep 09, 2025

Solved

Application.SaveAsText posible Bug

I'm discovering the powerful Application.SaveAsText and LoadFromText methods, never used before, and found that Application.SaveAsText acTable,... always produces an Error 2.487: The Object Type argu...

access

JF_Ruiz
Sep 10, 2025
You are always helpful. Thank you very much.

Before posting I made a web search about the method and only find information in https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/application-save-as-text where they mention as param ObjectType, without excluding tables...
🙌

Karl_Donaubauer

MVP

Sep 10, 2025

Hi,

It's not a bug but a known limitation. SaveAsText (and LoadFromText) cannot be used for tables. Instead you can use the TransferText method to export (and import) tables as text.

See e.g. Colin's description in point 1. (and 2.) here.

Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK

MendipDataSystems

Brass Contributor

Sep 15, 2025

Just to add that there is a way of using SaveAsText & LoadFromText that is mentioned in points 3 & 4 of my article that Karl linked above. However, that approach is only for use if you want to transfer all tables.