Import data from a text file (ADO) using VBA in Microsoft Excel

The procedure below can be used to get an ADO recordset from a text file and fill in the result in a worksheet. Sub GetTextFileData(strSQL As String,...

Import data from a closed workbook (ADO) using VBA in Microsoft Excel

If you want to import a lot of data from a closed workbook you can do this with ADO and the macro below. If you want to retrieve data from another wo...

Import data from Access to Excel (DAO) using VBA in Microsoft Excel

CopyFromRecordset is probably the easiest method of getting data from an Access table to an Excel worksheet. Sub DAOCopyFromRecordSet(DBFullName As S...

Import data from Access to Excel (ADO) using VBA in Microsoft Excel

With the procedure below you can import data from an Access table to a worksheet. Sub ADOImportFromAccessTable(DBFullName As String, _ TableName...

Export data from Excel to Access (ADO) using VBA in Microsoft Excel

We can export the data from Microsoft Excel to Microsoft Access by using VBA. Below is the VBA code and process which you need to paste in the code mo...

Replace text in a text file using VBA in Microsoft Excel

The macros below can be used to replace text in a text file, e.g. when you want to change a column separator in a text file before you import it int...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube