A
Aline
Hello!
I imported a sheet from Excel and I've added datas into a
table, using TransferSheet command for transfer, and a
query for add data.
In Excel the format is Text for all fields, but in the
table I have different formats for each field (number and
currency).
In Access 2000 it works fine, data is converted without
errors, but in XP is not so easy. I receive errors for
each field in other format that
I don't have any idea how to work this out.
I'm thinking to convert each fiels, by VBAcode but I don't
know how.
I welcome any solution,
Aline
I imported a sheet from Excel and I've added datas into a
table, using TransferSheet command for transfer, and a
query for add data.
In Excel the format is Text for all fields, but in the
table I have different formats for each field (number and
currency).
In Access 2000 it works fine, data is converted without
errors, but in XP is not so easy. I receive errors for
each field in other format that
I don't have any idea how to work this out.
I'm thinking to convert each fiels, by VBAcode but I don't
know how.
I welcome any solution,
Aline