Hello everyone -
I am trying to import a .csv file into an Access 2007 database.
The problem I am encountering is that when the information is imported to the table in the database, the data in the fields is all enclosed in quotation marks.
Is there a way to eliminate the quotes on import or a way to easily remove them once they are in the table?
Thank you in advance.
I am trying to import a .csv file into an Access 2007 database.
The problem I am encountering is that when the information is imported to the table in the database, the data in the fields is all enclosed in quotation marks.
Is there a way to eliminate the quotes on import or a way to easily remove them once they are in the table?
Thank you in advance.