Hi,
I am trying to perform export of a table in Access Database to a xls spreasheet.
For this I am using the command:
DoCmd.TransferSpreadsheet acExport, 8, "Report", Me!txtExportFileName, True
However I get a tick (') in the all the data exported. This happens for the fields which are of of...
Hi,
I am trying to perform export of a table in Access Database to a xls spreasheet.
For this I am using the command:
DoCmd.TransferSpreadsheet acExport, 8, "Report", Me!txtExportFileName, True
However I get a tick (') in the all the data exported. This happens for the fields which are of of...
Hi,
I am trying to change the Data Type from Text to Number- Double for a particular column in the Access Database.
This Table contains thousands of records.
While doing so I get the following Message:
Microsoft Access can't change the data type.
There isn't enough disk space or memory...
Hi,
I am new to VBA for Access.
I am trying to locate the specification file "ABC" provided in the following statement of VBA code.
DoCmd.TransferText acImportFixed, "ABC", "tblTextABC", filename
Can someone please tell me in what ways the specification files are created?
Thanks
- Amit
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.