Search : in
By :

How can I map one db into another similar db

Last answer on Oct 25, 2009 12:30:38 pm GMT GrievousAngel, on Oct 24, 2009 7:02:52 pm BST 
 Report this message to moderators

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

Configuration: Windows 7
Firefox 3.5.3

Best answers for « how can I map one db into another similar db » in :
Copying data into different cells using macro Show
Copy entire row from one tab into another Show
[Linux]Cutting a file into several parts Show [Linux]Cutting a file into several parts Linux is full of utility tools allowing you to manipulate files. There is a very handy tool to split a file into several parts (for example to carry data on low capacity media). The split...
Assembling multiple PDF files ShowAssembling multiple PDF files Intro Steps: Intro PDF creator is a software allowing you to print several files into one with its printer function. Download link http://en.kioskea.net/telecharger/telecharger-40-pdf...
Transforming columns into lines ShowTransforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
[Sed] Delete one or more lines from a file Show[Sed] Delete one or more lines from a file Removing one (or several) line (s) of a file Syntax: sed '{[/]||[/]}d' sed '{[/][,][/]d' /.../=delimiters n = line number...
Download SQL Converter Show
Download Codec pack all in one ShowCodec Pack All-In-One is a codec collection allowing to read films in DivX format and the similar formats (DivX, XviD, AC3, etc.). Codec Pack All in 1 6.0.3.0 contains: · DivX 6.1.1 · XviD Codec 1.1 · DivX, XviD - FFDShow 17.02.2005 Alpha...
Download Merge PDF Show
Ask your question Reply

1

iveal, on Oct 25, 2009 8:30:47 am GMT

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.

   
Reply to iveal

2

 GrievousAngel, on Oct 25, 2009 12:30:38 pm GMT

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



William Johnson (Billy)
Georgia USA

   
Reply to GrievousAngel
Ask your question Reply
They need your help