microsoft intregrity ?

[taz23340]

hi guys i have been using excel with all your help and i have a general ? for you all, i use frontpage for web design and i am trying to learn access to ease my work load. my ? is this. if i use these three together would it be better to have excel pull info from access and then send it to frontpage after having done some calculations or would it be better to you the excel options right in frontpage. any help would be great thanks.

 

[Smitty]

I think it would depend on the complexity of the calculations and the size of your dataset.

You might want to give a more detailed description of what you're trying to accomplish.

Smitty

 

[taz23340]

hi smitty,
what i have now is individual sheets for each of my ten teams in excel and that calculate the amount of players on each salaries, years on contract, etc.
what i was suggested to do is use a database to do this because at the moment when a player is traded, changes team i have to remove him from one team and add him to another and then resort the data and then copy paste to frontpage. i don't believe i can use a query from frontpage to excel only access or another database is what i was reading.
my issue is wheter i can use my sum and all that in frontpage using the excel portion instead of using excel. would skip me a step and save time. maybe this is more of an xp or frontpage ? i can try to find a frontpage forum to ask for help...

let me know
kevin

 

[Smitty]

I think I'd like Access for that kind of thing because you can keep all of your player data in a single table and just create individual queries by team.

But here's a FrontPage Forum.


Smitty

 

[taz23340]

thanks smitty i will check it out. do you know if it is hard to get excel to used the info stored in access and if it comes up in any resemblance of how we enter it in excel ourselves?

kevin

 

[Smitty]

Getting data from Access to Excel is really easy with Data-->Get External Data-->New Database Query & follow the wizard from there.

You can also copy/paste or paste special-->text, just note that if you've done Data-->Text to Columns in that instance of Excel, you'll need to exit and reopen.

The only issue with either is formatting.

Smitty

 

[taz23340]

tahnsk i will try it out