I'm trying to import a CSV into Access as a Text File. However, the data set imports with errors, where all Fields that are Numeric Values/Currency Values populate an error of Type Conversion Failure.
My data set has 4 columns that have numeric values for revenue and impression numbers. I assume this is error is being generated because the wrong data type is being selected in the upload process. What data set type should numbers below have? I'm trying to upload them all as long integers, but it's not working.
5,666,445
$55,666,667.08
Can you please help? Thanks.