I am using the TransferSpreadsheet Action in a macro to grab data from an Excel spreadsheet. It pulls in the numeric data fine, but the text data from Excel does not come over into the table that I'm putting the data in in Access.
Can anyone help?
Thanks!
Can anyone help?
Thanks!