Forum Discussion
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...
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...
🙌
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