Automate Import from Access to SQL Server through VBA in a ADP....

Hello,
I have a monthly dump that comes to us in access format. That dump
needs to be imported into sql server(Fromt end ADP) as part of the
monthly update routine. The process should go something like this:

1) ADP form opens up
2) click the update button
3) locate the .MDB
4) *VBA Code in the ADP imports the tables

* = Havn't figured this one out yet....

Can I just use SQL statements for this or is it going to be
complicated?

Thanks,
Chuck

re: Automate Import from Access to SQL Server through VBA in a ADP....

meyvn77@yahoo.com wrote:[color=blue]
> Hello,
> I have a monthly dump that comes to us in access format. That dump
> needs to be imported into sql server(Fromt end ADP) as part of the
> monthly update routine. The process should go something like this:
>
> 1) ADP form opens up
> 2) click the update button
> 3) locate the .MDB
> 4) *VBA Code in the ADP imports the tables
>
> * = Havn't figured this one out yet....
>
> Can I just use SQL statements for this or is it going to be
> complicated?
>
> Thanks,
> Chuck[/color]

Have you looked at using DTS for this? Much faster because it's not logged and
easy to schedule.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

re: Automate Import from Access to SQL Server through VBA in a ADP....

Thanks I think this will work out great....
When I save it as a .bas file how can I call that from VBA (not VB) in
the ADP. ?

re: Automate Import from Access to SQL Server through VBA in a ADP....

You don't have to save it as a .bas file. After you create your DTS
package, go to Access and include the DTS object library. Then you can
call it programmatically.
HTH
Pachydermitis