Before I upsized my access backend to SQL; I used a command button to automatically import several excel spreadsheets into an access table. I formatted the alphanumeric fields as text in the spreadsheet. Because the access would use it's own judgement and change my alphanumeric fields to number instead of text; I had to improvise by inserting the word "text" in the first field of the column and deleting it out of the table after import. It was dirty but it worked. Now that I have a SQL backend; is there any other way to have my imports maintain the spreadsheet format when automatically importing?
Thanks