help i need script asp VB to import data

[mortega33]

hi,
i need execute an asp page to do this:

Import data to dabasbase A to dababase B
The data are the same but the names of the tables are different.
The database are ms access format (in both cases).
..">D
Can you help me?
Thanks

[bruce]

Do you intend to do this often or is it just a one time deal?

I recommend you do this in your desktop environment rahter than using ASP Script.

[b]quote:Originally posted by mortega33

hi,
i need execute an asp page to do this:

Import data to dabasbase A to dababase B
The data are the same but the names of the tables are different.
The database are ms access format (in both cases).
..">D
Can you help me?
Thanks
</blockquote id="quote"></font id="quote">

B.

DiscountASP.NET
http://www.DiscountASP.NET

[mortega33]

Before upload the ddbb i execute the script. Often job.
Can you help me?
thanks

[steurm]

You might take a look at Stp Database Administrator, which you can download for free at www.stpworks.com/ (http://www.stpworks.com/). It is a powerfull administrator for your access database. you can import/export between different databases, just as if you were working in access itself.

--
Steurm
www.steurm.net/steurm

[infinitedes]

You should read their guestbook

Owen

[infinitedes]

As far as I know T-SQL will let you create a new table but it is
temporary. Therefore you'll have to go into Access and create a
new table. I could be wrong on this but I think bruce is right.

Owen

[steurm]

[b]quote:Originally posted by infinitedes

You should read their guestbook

Owen
</blockquote id="quote"></font id="quote">

Jep, a nice one [:D], but the administrator app is really good ...

--
Steurm
www.steurm.net/steurm