Hi all,
I'm having some issues when trying to export a table to excel. Basically when I export the data into a excel file (or csv) some of the data doesn't come through. The column names come through but no data is contained under them.
Here's a bit more infomation:
I have a table with 44 columns. When I export this table to an Excel sheet 3 of the columns don't contain any data. However I can see all the data (including the missing ones under the 3 columns) when viewing the table in Access itself. As far as I know there is no security/permissions features on the tables.
I need to export the tables as I need to create a Data Map for importing them back into MS CRM. I am fairly new to Access so any help will be greatly appreciated.
Thanks
Jarvis.
I'm having some issues when trying to export a table to excel. Basically when I export the data into a excel file (or csv) some of the data doesn't come through. The column names come through but no data is contained under them.
Here's a bit more infomation:
I have a table with 44 columns. When I export this table to an Excel sheet 3 of the columns don't contain any data. However I can see all the data (including the missing ones under the 3 columns) when viewing the table in Access itself. As far as I know there is no security/permissions features on the tables.
I need to export the tables as I need to create a Data Map for importing them back into MS CRM. I am fairly new to Access so any help will be greatly appreciated.
Thanks
Jarvis.