Hi there. I´am really new to building database, i´ve tried to make my research to find the answers, but wasn´t successful...
I´ve been working with excell pretty much and from what i´ve been thinking this is what i need:
1 - i use one excell spreadsheet a day to register 145 trades (some days more, some days less), but the spreadsheet in essence is the same (same columns i mean);
2 - from these trades i sum them up to make a control of the profit i have on each trade, and how much profit i make from each client.
3 - i was thinking on simply importing these daily spreadsheets into an access database to work with it through access instead of having lots of excell go arounds.
How can i make it automatic, i mean, how to import these spreadsheets one after the other?
Thanks
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks