I have a linked excel sheet.
I'm trying to import the data from that sheet to an access table.
The field in the excel sheet is called current_gp and formatted as percentage 0.00 so the data reads
16.00% for example
The field in the access table is formatted as text...trying to get the data imported correctly...but i need the percentage sign to be imported also..
If i need to change the formatting on the excel sheet i will.
But i cant change the field type in access..(which is "TEXT")