Hi,
I have an issue with the DoCmd.TransferSpreadsheet acImport command.
One of the import fields is a phone number which has all kinds of numbers such as 03 87698076, N/A, as well as mobile 6756434546 (majority). It appears it read the data as numeric and drops all data that is not numeric or has spaces.
Is there a way of importing and making this field Text so it does not drop this data.
I have tried formatting the excel but it does not work.
Thanks
Peter
I have an issue with the DoCmd.TransferSpreadsheet acImport command.
One of the import fields is a phone number which has all kinds of numbers such as 03 87698076, N/A, as well as mobile 6756434546 (majority). It appears it read the data as numeric and drops all data that is not numeric or has spaces.
Is there a way of importing and making this field Text so it does not drop this data.
I have tried formatting the excel but it does not work.
Thanks
Peter