S
Sandy Burgess
I have an excel file that I need to import into Access. I prefer to import
it as a text file so I can eliminate numerous columns of data that I do not
need using a Specification. The problem is a Sales column that is formatted
as Accounting in Excel. This Sales column wants to import the Sales data as
Text instead of Double. If I change the spec to use double, the negative
numbers end up on an error table and do not import. Is there any way to fix
this without having the user reformat the Sales data in excel?
it as a text file so I can eliminate numerous columns of data that I do not
need using a Specification. The problem is a Sales column that is formatted
as Accounting in Excel. This Sales column wants to import the Sales data as
Text instead of Double. If I change the spec to use double, the negative
numbers end up on an error table and do not import. Is there any way to fix
this without having the user reformat the Sales data in excel?