I have an imported table with lots of info in inverted commas such as "my name" "business type" etc. Is there a way to remove all the inverted commas? There are thousands of records so doing them manually is not an option. Thanks in advance

You can use the replace function to update data
Like

Replace("My Name",'"','""')

Replace("My Name",'"','""')
That would replace one double quote with two.

You need:
Replace([fieldname],'"',"")