In some Access export commands path length is limited. Could you remove those limitations?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Mitarbeiter", "C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooong directory\Very loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong filename.xlsx"
' Error 2006:
DoCmd.TransferText TransferType:=acExportMerge, TableName:="Mitarbeiter", FileName:="C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooong directory\Very loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong filename.txt"
' works. Add one ‘o’ and it doesn’t:
DoCmd.TransferText TransferType:=acExportMerge, TableName:="Mitarbeiter", FileName:="C:\Users\Gerrit.Viehmann\Desktop\Very looooooooooooooooooooooooooooooooooooooooooong filename.txt"1 vote
Thank you for posting.
The limitation in this case is on the filename itself, not the path. For file types, the database engine treats the file name as the table name in an external data source, so it enforces the limit on table name length, which is 64 characters.
At this point we have no plan of changing such a fundamental behavior in Access.
Please restore this feature, clearly by the number of ignored CUSTOMER requests in the past to restore, you clearly dont value your user are are technically unable to honor their wishes !!!3 votes
As you are probably aware, Pivot Charts and Pivot Tables have been removed from Access 2013 because the technology they relied on was deprecated (Office Web Components).
Since Pivot Charts as we all know them, will not come back to Access, we are updating the status accordingly and would like to encourage you to continue and use your free votes to support other suggestions.
this feature was removed from office 2013 and I dont understand why as its much easier for users to fill out a form that comes as outlook email.
Don't see any other feature we can use that are as simple and straight forward as that!52 votes
When creating forms and report Access use the standard naming
Labels as LabelsXX
Buttons as CommandXXX
And so ON
What users do is that they rename this after own preferences
Labels as lblNameofControl
Buttons as btnMyName
This naming option should be customizable for each user so they can set their own rules for how the labels or buttons or other controls should get their name in MS Access30 votes
Thank you for posting.
Unfortunately, enforcing a standard way of naming objects isn’t something we see high value in.
Microsoft Access and Microsoft Excel you would think would be hand in hand... but the problem has persisted for years that it has always been problematic getting the correct data types between Access and Excel columns when Importing and Exporting to and from Access to Excel and vice versa.69 votes
Excel doesn’t support data types which makes it very hard for Access to recognize data types from Excel when importing.
When using the wizard to import data from Excel, you can determine the column types and save the steps – this could be a workaround to mitigate the issue.
- Don't see your idea?