|
Home > Archive > MS Access Database with External Data > August 2005 > Automating Import of Excell data to Access
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Automating Import of Excell data to Access
|
|
| Jason V 2005-08-30, 8:29 pm |
| 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
| |
| Klatuu 2005-08-30, 8:29 pm |
| 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.
"Jason V" wrote:
> 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
| |
| Jason V 2005-08-30, 8:29 pm |
| Will do.....thanks.
"Klatuu" wrote:
[color=darkred]
> 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.
>
> "Jason V" wrote:
>
|
|
|
|
|