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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Adding data to MS Access from csv file 0
Accidentally clicked 'Don't Save' on a new Powerpoint presentation! Please help! 0
Csv import: direct link vs temp table dump 2
Dynamic Naming of Form Button 3
Trying to create custom labels from an csv file + Need items numerically counted out 0
Cannot import CSV file into ACCESS 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top