wkbk database

buz

Board Regular
Joined
May 30, 2002
Messages
230
I think I know the answer to this ....... I have a wkbk with a database which pivottables extract data from. I prefer to not add other columns of data to the DB, which would be one answer to my need. I would like to add a second database.

Question is - can the wkbk contain two databases? If so, what would you call the second database? If my memory serves me, the DB needs to be named 'database'.

tfyh

buz
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Swamp Thing

Active Member
Joined
Aug 16, 2002
Messages
313
You can put one table in each sheet of the workbook. The book will then look like a database with several tables. For example (using ms-query) the table from Sheet1 will be called Sheet1$, and so on. You can build your query accordingly.
This message was edited by Swamp Thing on 2002-08-28 21:11
 

buz

Board Regular
Joined
May 30, 2002
Messages
230
I think i recall reading that the database needs to be 'named' database.

Is this true? Or can I name a database anything I want.

I suppose experimenting is an option here, but don't want to mess with the database I have going now. Of course - experimenting with a copy would work too. Guess I'll try some experimental database naming.
This message was edited by buz on 2002-08-29 18:31
 

RichardS

Well-known Member
Joined
Feb 16, 2002
Messages
761
If you're talking extracting Pivot tables from one database, but based on different blocks of columns, you can define different names in the database, don't have to be "Database", and refer to those names in Step 2 of the Pivot Table Wizard.

Richard
 

Forum statistics

Threads
1,147,845
Messages
5,743,513
Members
423,801
Latest member
paulj4177

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top