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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CSV File Import Error
hi - here is a brief description of the issues that i am running across. i am using the following code to import .CSV files in my database. =============================================== Public Function pfImport() On Error GoTo Err_F Dim fso As Object, fol As Object, fils As...- Dire
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Exporting Access Data into Excel - Formatting Issues
i checked that in excel and all options are un-ticked in Tools > Options > Transition i have tried Transferspreadsheet and OutputTO in Access VBA to export, and both of them are giving the same issue. is there any other function that i could use to export. thanks.- Dire
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Exporting Access Data into Excel - Formatting Issues
thanks for your reply. if i don't want the ' (excel's text identifier) to be present in the output file, how can i accomplish that? reason i ask is that the output file from the db is input for some other application and that application needs that the text fields don't have ' in them...- Dire
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Exporting Access Data into Excel - Formatting Issues
I have used DoCmd.TransferSpreadsheet method to export data from an Access DB into Excel. the following is an example of the code: CODE: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, sQueryName, strPath The problem i have is that, in Excel, all text field cells are exported...- Dire
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
