cancel
Showing results for 
Search instead for 
Did you mean: 

Import Multiple tables in a Datastore

Former Member
0 Kudos

Hi Experts,

I am having to import around 800 tables in a single datastore . Is their anyway I could do it one stretch or in batches.

Other than importing them one by one.

Your answers would mean a lot.

Thanks

Arun.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member187605
Active Contributor
0 Kudos

Open the datastore to display the external metadata. Select all tables you want to import. Right-click and select import from the pop-up.

Former Member
0 Kudos

Thanks for the reply Dirk Venken,

The trouble here is I have around 5000 tables out of which, I will have to select only 800, its still tedious for me browse the tables one by one and then to import them as whole.

I have the list of table names in an excel sheet to be imported.

Is there any other better way to fix this