Problem with data type when importing CSV via VBA

[raynman1972]

Hello,

I am an Access rookie. I am trying to import a CSV file that has a number column that can vary (1,11, 111.001101, 11.000001) and when I try to import this via VBA, I can't seem to make it work without calling it a Text field. My challenge with the data is that I cannot control the formatting as I am getting the files from various parties and I need some way of programmatically rounding this out to the nearest whole number.

I have encountered this before with Access and imports, but it was only with dates and times. I was able to work around these by putting in a module that makes a new column and copies the data over as the proper data type and this works- just not sure how to do this for varying integer/double/long data types.

Any thoughts?

Cheers,

Ray

[June7]

I was experimenting with this just yesterday. Only opposite issue, the import wouldn't accept text values in a field where the values were a mix of alphanumeric. Example: 132789, 132789S1. Insisted on reading the field as numeric and rejecting the S1 suffixed values. Finally saved the CSV as an Excel workbook then the import worked.