Automating Import of Excell data to Access

J

Jason V

This is my first time working with importing data. I have payment files in
excell that I want to import(but only two of the fields out of several) into
an existing Access payment table.

Payment table (Access) consists of following fields:
Reference Number Payment Date Payment Amount Payment File Name

The two fields I want to import from the excel payment file are "Reference
Number" and "Amount".
"File name" is the name of the Excel file the user is importing, "Payment
Date" will be keyed by the user. I will use code to fill these fields in for
each record.

I don't really know where to begin, I want the user to choose the payment
file and enter the payment date and have the rest automated.

Any advice to get me started in the right direction?
Thanks,Jason
 
K

Klatuu

Jason,
First, look in Help for the TransferSpreadsheet method.
Next, This question has been answered in this group countless times. Read
through this news group and you will find everything you want to know.
 
J

Jason V

Will do.....thanks.

Klatuu said:
Jason,
First, look in Help for the TransferSpreadsheet method.
Next, This question has been answered in this group countless times. Read
through this news group and you will find everything you want to know.
Click to expand...
 

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

Excel - Wich Function should I use? 1
Access 2003 --> Access 2007 code no longer working 6
Refresh field 0
Query Help One-to-Many 4
record spanning more than one line 1
Another Question on Subforms 3
How do I find the last record ? 7
Display data from database, that match selection in listbx 0

Top