help creating a button to import .csv file... and more..

B

Brook

good day all,

I am trying to create a command button to import a csv file into a
temporary table... once in the temp table have the data added to a main
table?

I have the following:

tblcheckingimport - temp table
tblecheckingaccount - main table

I have tried everything...

Thanks, in advance for any help!! or suggestions!

Brook
 
P

pietlinden

good day all,

 I am trying to create a command button to import a csv file into a
temporary table... once in the temp table have the data added to a main
table?

I have the following:

tblcheckingimport - temp table
tblecheckingaccount - main table

 I have tried everything...

Thanks, in advance for any help!! or suggestions!

Brook
Click to expand...

on please. Everything?
How about TransferText to import the file to the temp table and then
an append query to move the data from the temp table to the main table?
 
Top