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!
-
Access vba code to Export tbl data to Excel spreadsheet
The problem with that is: I am not allowed to change any formatting/coding in the Excel doc because I am not the only one that uses it. I can only insert new data.- ckeola
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access vba code to Export tbl data to Excel spreadsheet
I have been trying different stuff and at my ropes end with this one.... this was my latest attempt. Private Sub Command61_Click() DoCmd.TransferSpreadsheet acExport, "Microsoft Excel", "C:\folder\my_Excel", _ acTable, "my_tbl", _ End Sub The errors I get range from type mismatch to... lets...- ckeola
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access vba code to Export tbl data to Excel spreadsheet
every time I try to code something it doesn't work. I need code... simply because I have 20,000 rows of data that I have to check through and any time I can shave off (like copying and pasting/CSV)- ckeola
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access vba code to Export tbl data to Excel spreadsheet
I have tried and tried... and am not vba savvy... :( I have a form in an Access db that has a button that I need to be able press and it exports tbl data to Excel. Access Database I am working from: "my_db" Table I need to export(w/out headers): "my_tbl" Excel workbook(already exists) I need to...- ckeola
- Thread
- Replies: 12
- Forum: Microsoft: Access Modules (VBA Coding)
