How can I export data from an excel sheet to a table in access? The spreadsheet and the table have exactly the same columns. It seems it is possible to import from access but not export to Access. Does anyone have any information?
Thanks.
How can I export data from an excel sheet to a table in access? The spreadsheet and the table have exactly the same columns. It seems it is possible to import from access but not export to Access. Does anyone have any information?
Thanks.
Save the excel file.
Open Access and the required database.
Go to the database navigator form, and right click on the Tables button onteh right hand side.
There is an import wizard there that will open the excel file.
Kieran
Thank you Kieran. In fact I would like to export to Access, and not import from Excel. In other words, I want to do it from Excel, not from Access. Is that possible?
Why do you need to 'push' the data to access.
Using the Access linked table wizard, you can directly pull the datya from an excel file, or even a csv.
Would this be simpler.
Otherwise you will likely be using OLE to run Access from within Excel. I have little experience in that, however there are a lot of experts around here that could assist.
Thanks again.
I would like to do it all from excel, though it seems easier to use access to import the data...
I'll see if someone else has any other idea related to using OLE to send the data from excel to access.
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks