Excel Database and Exporting
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Excel Database and Exporting

 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services
Author Message
Rolando
Guest
Posted: Wed Jan 19, 2005 5:25 am    Post subject: Excel Database and Exporting Reply with quote
Hi,

I just created an internal site at work. One of the features is a shared
database. The database originated from an Excel document that I imported.
Couple of questions:

1. How can a user do a multiple criteria search, then export just those
results and not the entire database?

2. How are formulas treated in a database that was imported from Excel?

Thanks,
Rolando
Back to top
Mike Walsh
Guest
Posted: Wed Jan 19, 2005 6:49 am    Post subject: Re: Excel Database and Exporting Reply with quote
You don't create a database from Excel. (at least not using WSS - this
newsgroup)

You create a custom list in WSS from Excel.

Can you confirm that this is what you mean before we look at this.

Otherwise I suspect that you have posted to the wrong newsgroup.

Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.


"Rolando" <Rolando@discussions.microsoft.com> wrote in message
news:D7DB03E7-700C-4BBF-816D-48C4B7880FAB@microsoft.com...
Quote:
Hi,

I just created an internal site at work. One of the features is a
shared
database. The database originated from an Excel document that I imported.
Couple of questions:

1. How can a user do a multiple criteria search, then export just those
results and not the entire database?

2. How are formulas treated in a database that was imported from Excel?

Thanks,
Rolando
Back to top
Rolando
Guest
Posted: Wed Jan 19, 2005 9:19 pm    Post subject: Re: Excel Database and Exporting Reply with quote
Hi Mike,

Thanks for your response. I have done it both ways, once with importing
Excel and once by creating a custom list within WSS. In either case, I want
to be able to customize my export of data base on any given search criteria.

When viewing a document, in the upper right hand corner there is a open
field search box. I would like to be able to search for data, say BlackBerry
for example, then have the result show only those items with BlackBerry, then
be able to print only those items. As of now, it exports the entire database.

If possible I would also like to search by more than one criteria, for
example, BlackBerry and India.

Thanks,
Rolando

"Mike Walsh" wrote:

Quote:
You don't create a database from Excel. (at least not using WSS - this
newsgroup)

You create a custom list in WSS from Excel.

Can you confirm that this is what you mean before we look at this.

Otherwise I suspect that you have posted to the wrong newsgroup.

Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.


"Rolando" <Rolando@discussions.microsoft.com> wrote in message
news:D7DB03E7-700C-4BBF-816D-48C4B7880FAB@microsoft.com...
Hi,

I just created an internal site at work. One of the features is a
shared
database. The database originated from an Excel document that I imported.
Couple of questions:

1. How can a user do a multiple criteria search, then export just those
results and not the entire database?

2. How are formulas treated in a database that was imported from Excel?

Thanks,
Rolando


Back to top
Mike Walsh
Guest
Posted: Wed Jan 19, 2005 10:19 pm    Post subject: Re: Excel Database and Exporting Reply with quote
I'm still lost by the usage of database in this connection so I'll pass and
hope someone else has been having a better day than me.

Anyone ?

Mike Walsh, Helsinki, Finland

"Rolando" <Rolando@discussions.microsoft.com> wrote in message
news:DE565CEE-C1F0-4F1A-9A69-8A12ADDFD967@microsoft.com...
Quote:
Hi Mike,

Thanks for your response. I have done it both ways, once with importing
Excel and once by creating a custom list within WSS. In either case, I
want
to be able to customize my export of data base on any given search
criteria.

When viewing a document, in the upper right hand corner there is a open
field search box. I would like to be able to search for data, say
BlackBerry
for example, then have the result show only those items with BlackBerry,
then
be able to print only those items. As of now, it exports the entire
database.

If possible I would also like to search by more than one criteria, for
example, BlackBerry and India.

Thanks,
Rolando

"Mike Walsh" wrote:

You don't create a database from Excel. (at least not using WSS - this
newsgroup)

You create a custom list in WSS from Excel.

Can you confirm that this is what you mean before we look at this.

Otherwise I suspect that you have posted to the wrong newsgroup.

Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.


"Rolando" <Rolando@discussions.microsoft.com> wrote in message
news:D7DB03E7-700C-4BBF-816D-48C4B7880FAB@microsoft.com...
Hi,

I just created an internal site at work. One of the features is a
shared
database. The database originated from an Excel document that I
imported.
Couple of questions:

1. How can a user do a multiple criteria search, then export just
those
results and not the entire database?

2. How are formulas treated in a database that was imported from
Excel?

Thanks,
Rolando


Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB