Import Mapping from .csv

[Nothnless]

Hello, I have a database that auto imports excel worksheets via macro button. However, some of the columns in the worksheet have alphanumeric characters which messes up the Access tables during the import. My work around is to save the worksheet as a .csv file, map the format I want for each column, and have Access import the .csv file. My problem is, I dont know how to import map a .csv file. Can anyone help map the file in the link below so Access can import it correctly? Its just a test file with 4 columns and 4 rows, but it will help get me started. Thanks!

https://1drv.ms/u/s!AmSI_zScjZJQkHMfccACXzKzRXvS

 

[bobsan42]

thanks xenou

 

[xenou]

@Nothnless if you still have problems suggest your provide sample data and write down all the steps you are going through - also if you are using a predefined table, or not (creating a new table) and if so what the data type is in the table.