HomeForum
Welcome, Guest

Retrieve data from multiple db tables and insert the data into a single table.
(1 viewing) (1) Guest
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: Retrieve data from multiple db tables and insert the data into a single table.

Retrieve data from multiple db tables and insert the data into a single table. 1 year, 1 month ago #2569

  • jarrod
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
I'm trying to retrieve data from multiple db tables and insert the data into a single table.
I'm not getting all the fields to map.
Is this possible?

J

Re: Retrieve data from multiple db tables and insert the data into a single table. 1 year, 1 month ago #2570

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Hello

Sorry, it is not very clear what do you mean
Can you post here a screenshot please.

John,
Db Software laboratory

Re: Retrieve data from multiple db tables and insert the data into a single table. 1 year, 1 month ago #2571

  • jarrod
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Mike,

I'm sorry I forgot to mention that I was working with "Data Exchange Wizard".
I was trying to take info from multiple MS Access db tables and copy the info into a single postgresql db table.
I wanted to know if there was a way to do this with the "Data Exchange Wizard".
When mapping the fields of the source tables to the fields of the target table, the wizard kept the mapping of fields from multiple data, but the results look like only the fields from the source table, that was showing, were being populated.
Any help will be appreciated.

Thanks,
Jarrod

Re: Retrieve data from multiple db tables and insert the data into a single table. 1 year, 1 month ago #2572

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
So you are saying that yo have one MS Access Database with several tables you would like to load.
Those tables have they got identical structure eg field's names, field's order?

John
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

Our prior imports were done using VB. Our VB expert retired. No one in my group knows VB. So Visual Importer was the answer to the lack of VB skills problem my group experienced.
Ron Bradshaw,
IT Reporting Manager,
ConAgra Foods / Lamb Weston

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top