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

  • Thread starter Thread starter Brook
  • Start date Start date
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
 
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?
 
Back
Top