In Post #11, I attached the imported Excel to the Access table as a zip file. But when I imported the modified Excel file to MS Access all kinds of problems occurred. That was the purpose of the post.
I thought in that system, I converted all numbers to text and then I imported the all text Excel file to MS Access. The result is attached to Post # 11. It clearly was not the same, the Access table looked very different than the Excel worksheet.
You say it worked. How did you do it? The apostrophe did not make it over. That is alright. It would have been taken out anyway.
But the rest.
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed