ADO export table form Excel to Access

[jaryszek]

Hi Guys,

I have Hyperlinks in my table and i cannot them send to Access database:

Please Login or Register  to view this content.

When i have in example cell : "C:\Users\ljar01\Desktop\Test_nowy" formatted as text this is working.
When i have isted of "C:\Users\ljar01\Desktop\Test_nowy" formatted as hyperlink this also working but this is not working in my others Excels when i am loading query.

When i am using HYPERLINK instead TEXT in ZdanieSQL there is a problem "Syntex error in field definition".
All i want to export link to access and next after loading this in query to have also working hyperlink.

Have you ever had similar problem?
Please help,
Thank you in advance
Jacek Antek

[jaryszek]

No help with this?

Jacek