Removing characters from a linked table

[RichardMGreen]

Hi all

I have a CSV file linked to an Access table.
Unfortunately, the CSV file has quotation marks (") at either end of each field.

Is there a way of getting Access to ignore the quotation marks so instead of a field reading
"This is the field item"
you get
This is the field item.

I don't really want to have to open the file and do a find and replace manually if it can be done in VBA?
If it helps, I'm already using VBA to repoint the path of the linked table if necessary.
I'm also using code to run a series of macros to build some temporary tables.

If it could be included as part of that, or if anyone has any other ideas, I'd be very grateful.

::edit::

Just a quick add-on, if I open the CSV in Excel, I don't get the quotation marks around each field.
Anyone know why that is?

 

[SydneyGeek]

As you say,

Given that the average size of the files is around 32MB, that wouldn't make SSE choke but leave well enough alone...

Denis

 

[RichardMGreen]

Probably a good choice.
We've got SSMS installed so we have full SQL Server 2008 which would be even quicker, but they don't see it like that.