Forum Discussion
DomStam
Mar 01, 2021Copper Contributor
Problem with Exporting from Access to excel .xlsx file type
I have a form in Access that contains a column of suppliers among other items. When I export to .xls all is fine and appears as it does in Access. But when I export to .xlsx file one of the supplier names gets concatenated with another spelling of the same name. Almost like its auto filling in the name. Example - a supplier is CompanyX in Access and .xls files. But in the .xlsx file it comes out as CompanyXCompanyyX This also happens if I do a straight cut and paste into excel.
Any ideas are very much welcome.
2 Replies
- kmohanreddy20051735Copper ContributorAre you using VBA macro to export?
Is the company field in the Access table a hyperlink field?