IMPORTING CSV FILES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

MY CASH REGISTER SYSTEM CREATES CSV FILES ON MY COMPUTER AFTER POLLING THE REGISTERS
I WOULD LIKE TO CREATE AN ACCESS DATABASE, LOAD THE CVS FILES INTO THE DB AND WRITE MY OWN REPORTS

TH

HOWARD
 
HRASCOLL said:
MY CASH REGISTER SYSTEM CREATES CSV FILES ON MY COMPUTER AFTER POLLING THE REGISTERS.
I WOULD LIKE TO CREATE AN ACCESS DATABASE, LOAD THE CVS FILES INTO THE DB AND WRITE MY OWN REPORTS.

THX

HOWARD
Click to expand...
Please don't use all caps. It makes it hard to read you message.

In the menu go to File/Get External Data/Import. Select the file and
click Import. Access will import your data.
You can also go to the Table tab and click New/Import and do the same thing.
Most developers import to a temp table and then use an Append query to
add the new data to a master table.
By using a temp table, it allows you the ability to edit the data by
useing a query or running some vba code
against the temp table before you append it to your good data table.

You can create an import form and put all of your code behind a command
button. This will give you
more control over the execution of the program in the event you have
data errors and do not want to append
the new data to your master table.


Ron
 
Back
Top