importing CSV into Access 2010
Posted on 2013-05-28
I have a large .CSV file, with four columns ( three text data types and a date field).
One column, which is a text data type has contents with both alphanumeric ( FR347726, GB228765, 3987663, FR209878) and numeric data.
I created a button in an access form, that enables me to browse to file location and import the 'csv file' into a table. The table data types are the same as cvs file ( date field and 2 text fields)
Problem is that all the alpha numeric data in the lost once the import into access table happens.
How can i prevent the alphanumeric data from being dropped, without tweaking the csv contents..Maybe some like of code? please help.