Search results for query: *

Dear all, I have encounter a problem of having text fields longer than 255 characters (impossible to create a table using design view, because the only provided option is TEXT(255)). Thus, I have decided to create my table trough a module using a SQL statement: DoCmd.RunSQL "CREATE TABLE...

Thank you for the hint on code reduction (but I still get the same error) Method of file member not found. Variable definition: Dim MIR_tb As TableDef To answer your questions: 1. All provided variables are defined MIR_sql_tb as string where I create a local table So, within this task...

Dear all, This is the first time I am doing this, so please excuse me if it is a stupid question or a wrong data import approach. The problem in my code is to populate an Access table from a DAO table that gets data from an external .csv file (importing trough an Access GUI is impossible)...

Thank you for the reply. It took some time, but I understood the concept and the import method (as well as the statement that I posted). My next problem is execution of the desired properties. Have been looking for code samples and more or less put the pieces together. However, when data...

Dear all, I am looking to a friendly solution to import a csv file (csv files are imported randomly, many times per month) with 5 columns into a new table in access that has more columns that the file I am importing). Problem description: 1. two columns have meta data information and need to...