07-07-03, 15:03 #1Registered User
- Join Date
- Jul 2003
Unanswered: Import from Excel without Data Type
What I want to do seems simple enough, so here it goes. I want the user to be able to click a button to import an Excel Spreadsheet, which then is used for queries and such. However, I need the Spreadsheet to be imported to a table but have the data type be text for all entires. It must be this way because of the nature of the data.
Any thoughts on how to go about this would be greatly appreciated.Life's a bowl of punch, go ahead and spike it.