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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Transfer Data from Excel to Access
Yes I did...but don't know how to put this all together.- Vishesh78
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Transfer Data from Excel to Access
This is what I do...manually open Access and use Get External Data option to import into Access. However, I want to automate this from Excel...In Excel I want to write a function that takes excel range, access db and table as parameter and uses Access's Docmd.transferspreadsheet command...all...- Vishesh78
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Transfer Data from Excel to Access
I have around 300,000 rows of data in Excel that I need to export to Access. One way to do that is to loop through the data and add records one by one. Another, manually open Access and use Get External Data option to import into Access. However, I want to automate this latter option from...- Vishesh78
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
