Incomplete Data Export - when exporting a table to excel

[JarvisC]

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.

 

[DCrake]

Simple Software Solutions

How are you exporting to Excel?

As an exercise bring up the table/query in Access, select all records and copy. then select Tools > Analyse in Excel. This should copy the source into a new Excel spreadsheet any erros will be prompted. If all records go accorss into Excel then something else is causing the problem.

CodeMaster:

 

[JuriSim]

Perhaps there are too many records in your Acc Table? Excel is limited to approx. 65000 records