Previous Topic Next Topic

How can I map one db into another similar db

Closed
GrievousAngel Posts 5 Registration date Friday 23 October 2009 Status Member Last seen 7 May 2010 - 24 Oct 2009 à 14:02
GrievousAngel Posts 5 Registration date Friday 23 October 2009 Status Member Last seen 7 May 2010 - 25 Oct 2009 à 08:30
Hello,

I need help to map my eBay db into another system (Vendio) to get into other markets.

the db's are very similar of course but the fields (cells) are in a different order. if i had a script (batch operation) to do this in Access or Excel would be great!

All suggestions and details very welcome.

Sincerely thankful,

billy
Related:

1 response

Réponse 1 / 1
Blocked Profile
25 Oct 2009 à 04:30
Dear Sir,

Please try using the following information:

SqlCon.Open()

SqlDataAdapter.fill(Dataset1)

SqlCon.ChangeDatabase("DestinationDatabase")

SqlDataAdapter.InsertCommand.CommandText = SQL Query + (Dataset value)

SqlDataAdapter.InsertCommand.ExecuteNonQuery

It will be easy to do and it should solve the problem that you are having, thanks.
GrievousAngel Posts 5 Registration date Friday 23 October 2009 Status Member Last seen 7 May 2010
25 Oct 2009 à 08:30
hello iveal,

thanks for the help.

can you please list a brief basic outline of what i need to do to activate this script?

i understand that i need to copy/paste your script into a exe file via notepad or some editor, correct?

where in Access do i start the script? do i need to open both related db's first or is that info requested once the script starts?

again thanks for the reply and help. i have used scripts in Photoshop but never in MS products.

later,
Billy