Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing Excel data to Access 1
- Thread starter hahnsm
- Start date
-
1
- #2
Hi hahnsm,
Coincidentally, I have recently posted an example of one way of doing this at
The file to look at is Import a Spreadsheet using a Common Dialog.zip .
This demonstrates the TransferSpreadSheet Method. Help, will show all the available options using TransferSpreadSheet.
Hope this helps
Bill
Coincidentally, I have recently posted an example of one way of doing this at
The file to look at is Import a Spreadsheet using a Common Dialog.zip .
This demonstrates the TransferSpreadSheet Method. Help, will show all the available options using TransferSpreadSheet.
Hope this helps
Bill
Hi Kherozen,
You had me worried there for a moment, I've just downloaded it on to my laptop. Works perfectly.
No there's no setup procedure.
What operating system are you trying to run it on?
Can you email your download to me at billpower@cwcom.net
so that I can see if anything's gone wrong with the file during download.
Bill
You had me worried there for a moment, I've just downloaded it on to my laptop. Works perfectly.
No there's no setup procedure.
What operating system are you trying to run it on?
Can you email your download to me at billpower@cwcom.net
so that I can see if anything's gone wrong with the file during download.
Bill
- Thread starter
- #5
Bill:
Thank you so much for the code but I can't get my file to save to a table in my Access Database. I would really like to import it to an exsisting table without overwriting current information in my subdatasheets. Is there code that I can add so that only new or different information can be added??
You may also respond to me at Sadie_Goodrich@bd.com
Thank you so much for all of your help!
Sadie
Thank you so much for the code but I can't get my file to save to a table in my Access Database. I would really like to import it to an exsisting table without overwriting current information in my subdatasheets. Is there code that I can add so that only new or different information can be added??
You may also respond to me at Sadie_Goodrich@bd.com
Thank you so much for all of your help!
Sadie
Hi jul ^_^,
It downloaded ok.
Not having XP myself, the only thing I can suggest is to open the DB while keeping the SHIFT key depressed. Then convert the DB to your current version.
Another thing you could do is download the Access 97 version and see if that converts ok.
Lastly, as I said, don't have XP, is comdlg32.dll located on your HD, this app depends on that. Maybe XP uses a newer version? I don't know.
This is a real mystery, all this app does is make a couple of API calls to the above DLL.
Let me know how you get on.
Bill
BTW Have just posted Import Multiple Excel Worksheets into Access at
Maybe try downloading that, converting it first to XP. There should be a help file with sometime tomorrow.
It downloaded ok.
Not having XP myself, the only thing I can suggest is to open the DB while keeping the SHIFT key depressed. Then convert the DB to your current version.
Another thing you could do is download the Access 97 version and see if that converts ok.
Lastly, as I said, don't have XP, is comdlg32.dll located on your HD, this app depends on that. Maybe XP uses a newer version? I don't know.
This is a real mystery, all this app does is make a couple of API calls to the above DLL.
Let me know how you get on.
Bill
BTW Have just posted Import Multiple Excel Worksheets into Access at
Maybe try downloading that, converting it first to XP. There should be a help file with sometime tomorrow.
Hi Sadie,
Try my latest post, it doesn't have a helpfile yet, but you can specify to save the import to a new table.
You can find it at the address above.
Though it says Multiple in the title, there is the option for single sheet imports.
There isn't a help file yet, but if you have any questions, just ask.
All the best
Bill
Try my latest post, it doesn't have a helpfile yet, but you can specify to save the import to a new table.
You can find it at the address above.
Though it says Multiple in the title, there is the option for single sheet imports.
There isn't a help file yet, but if you have any questions, just ask.
All the best
Bill
- Status
Similar threads
