joeman said:
need to import Excel spreadsheet with text fields and return back to Excel
numeric field without adjusting the table structure (user interface is
only
through Swithboard). any suggestions
Don't think there's any easy way of doing this. You'll have to write some
code to create an Excel object, open the spreadsheet, get the required data
and post the new data back into your spreadsheet.
You need to add a reference to the 'Excel Object Library' then you will have
access to all the necessary Excel Objects to acomplish your requirements.
I have done somthing similar though it was a VB application, not an Access
one. If you are a fairly competent programmer then it's not too hard. Before
you ask, sorry but I don't have access to the code that I wrote on this.
Actually, there might be an easier way, depending on the layout of your
Spreadsheet. If it is a simple DataTable formatted spreadsheet, you can
create a new 'Linked' table in your Access application that links to the
spreadsheet, then you can read and write values as if it were another
table...
Good Luck!
Chris.