Trying My Supplier's Database

[DPP]

I am a promotional products supplier. I am trying to get my site
similar to http://www.cawholesale.com. My site is
http://www.dallaspromotionalproducts.com. I have a supplier
http://www.foractivewear.com that has several items that I would like
to put and use in my own database. Is there a way to import this
information into my access database or do I need to find another route.
I am stumped as to how cawholesale go all of there information and I
am assuming that they have their own database.

Thanks in advance for any help.

 

[Guest]

DDP;
This method is a little dangerous unless you have good security in
your system! I also hope you have some SQL experience.

You can use the Execute.YourConnection("Create Procedure QueryName
Select * From Field1, Field2, Field3, Field4")

This will create a query in an Access DB or SQL DB with the criteria
of the selected records.

Your can also remove the old query if necessary with the:

Execute.YourConnection("Drop Procedure QueryName")

Good Luck!