Write to Excel from Access

[aw23]

I have a function in my program where the user can import a spreadsheet from Excel to Access. On the form there are several txtboxes where the user selects the path, name, range, etc. This works great. Now I'd like to add a field where the user enters data that needs to go into the db along with the spreadsheet, in the same records. So that I can either add the data to Excel and then import or import and then update in access. I'm kinda stuck on this. I think the best way would be to add it to the Excel file. I have opened the file from access but do not know how to write to it. I have programmed in Excel VBA and I know how to write to an Excel file through code, I just don't know how to do it from Access.

Any suggestions?
Thanks

 

[kevinnichols78]

Are you trying to output multiple data or just one item?

Kevin

 

[aw23]

Just 1 item.