This Access VBA tutorial explains how to import and export Access Objects to text using DoCmd.TransferText Method.
You may also want to read
Access VBA Export all Queries to Excel
Access VBA import txt using DoCmd.TransferText Method
Syntax of DoCmd.TransferText Method
DoCmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)
Name
Required/Optional
Data Type
Description
TransferType
Optional
AcTextTransferType
T...
Read More
Microsoft Access VBA Export all Query to Text File
This Access tutorial explains how to use Access VBA to export all Query to Text file.
You may also want to read:
Microsoft Access Export all Queries to Excel
Access VBA DoCmd.TransferText Method
Export Access Objects to Text (non VBA)
There are two kinds of export that we can use to export an Access object to Text file.
Assume that we want to export Query1 to Text. Right click on the Query > Export > Text File
This page has a check box Export data with format...
Read More
Microsoft Access Export all Queries to Excel
This Access tutorial explains how to export all Queries to Excel.
You may also want to read:
Access VBA auto generate mass report by group to Excel
Microsoft Access Export all Queries to Excel
Assume that you have created three Queries in Access database, all you want to export them to Excel.
Press ALT+F11 > insert a Module > paste the below code
Public Sub export_Excel()
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Set db = CurrentDb()
For Each ...
Read More
Microsoft Access UNION and UNION ALL
This Access tutorial explains how to use UNION and UNION ALL in Access Query.
You may also want to read:
Excel VBA Union Method
UNION and UNION ALL in Access
UNION and UNION ALL are used to combine two Query results vertically into one Query, therefore both Queries require to have the same number of fields and same data types.
When two Queries are combined, there could be rows of record that are exactly the same (duplicates). UNION removes all duplicates while UNION does not remove an...
Read More
Run Access Macro using RunCode
This Access tutorial explain how to run Access Macro using RunCode.
You may also want to read:
Run Excel Macro from Access VBA
Run Access Macro
Assume that you have already written a Sub Procedure helloWorld(). To run the Macro, you can press ALT+F11 and run the Procedure by pressing F5.
Alternatively, go back to the Access Windows, double click on the Module on the left hand side and run the Procedure by pressing F5.
If you are writing a Macro for users, they pro...
Read More
Add Auto number in Access Query
This Access tutorial explains how to add auto number in Access Query using Access VBA Function.
You may also want to read:
Sort Data in Access Report
Add sorting in Access Table field
Add Auto number in Access Table
In Microsoft Access, go to Design View of a Table and define the Data Type of a field as AutoNumber
Go to data view of the Table, each row of data is assigned a sequence number in ascending order.
However, we cannot add the AutoNumber Data Type in Q...
Read More
SPSS Select Cases (filter data)
This SPSS tutorial explains how to filter data using Select Cases Function.
SPSS Select Cases (filter data)
In Excel, you can apply Autofilter and enter criteria to select data what you want. SPSS has similar function but it is called "Select Cases". In this tutorial, we will talk about the options are available to facilitate data filtering.
Navigate to Data > Select Cases
There are several options in this Select Cases box. We will talk about each option in the below sec...
Read More
SPSS Import Text File
This SPSS tutorial explains how to import text file into SPSS.
SPSS Import Text File
Navigate to File > Open > Data
Select Text in Files of Type, and then select the target text file
Step 1
Does your text file match a predefined format?
Leave the option default as No if this is the first time you import this file.
Select Yes if you have previously saved the format in your last import.
Step 2
How are your variables arranged?
Wh...
Read More
SPSS define variables in Variable View
This SPSS tutorial explains how to define variables in Variable View.
You may also want to read:
Types of data in statistics (Interval, Nominal, Ordinal)
SPSS - Variable View
In SPSS, understanding the Variable View is the first step before using any analytic functions. The purpose of Variable View is to define variables.
In Excel, you don't have to define whether a column is number, date, or text, because Excel guesses the data type for you but of course it could be wrong in some cas...
Read More
Access VBA DoCmd.TransferSpreadSheet Method
This Access tutorial explains how to use DoCmd.TransferSpreadSheet Method to export and import files.
You may also want to read:
Access VBA DoCmd.OutputTo Method
Access VBA auto generate mass report by group to Excel
Access Export all Queries to Excel
Syntax of DoCmd.TransferSpreadSheet Method
TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA)
Name
Required/Optional
Description
TransferType
Optional
The type of transfe...
Read More