Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I import from Access to Excel
Hi All, I've a sheet which contains all my team members names and the work assigned to them. In that sheet I want to export that data to access so that an individual can see his own data rather than seeing all. Any Ideas?????????? Thanks in Advance... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I import from Access to Excel
If you need to transfer it once, you can just import it inte your
acces database. Otherwise you could link your excel table. Does that help you? Carlo On Dec 27, 1:50*pm, Srikanth wrote: Hi All, I've a sheet which contains all my team members names and the work assigned to them. In that sheet *I want to export that data to access so that an individual can see his own data rather than seeing all. Any Ideas?????????? Thanks in Advance... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I import from Access to Excel
Carlo,
Can you let me know how to link??? "carlo" wrote: If you need to transfer it once, you can just import it inte your acces database. Otherwise you could link your excel table. Does that help you? Carlo On Dec 27, 1:50 pm, Srikanth wrote: Hi All, I've a sheet which contains all my team members names and the work assigned to them. In that sheet I want to export that data to access so that an individual can see his own data rather than seeing all. Any Ideas?????????? Thanks in Advance... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I import from Access to Excel
Hi Srikanth
Open your Access Database (Please tell me which Version it is). Go to your Database-wndow (F11) Go to Tables Rightclick on a blank spot and select "Link Tables..." The wizard should explain itself. If you still have questions, just post them here, or in the access database newsgroup cheers Carlo On Dec 27, 7:31*pm, Srikanth wrote: Carlo, Can you let me know how to link??? "carlo" wrote: If you need to transfer it once, you can just import it inte your acces database. Otherwise you could link your excel table. Does that help you? Carlo On Dec 27, 1:50 pm, Srikanth wrote: Hi All, I've a sheet which contains all my team members names and the work assigned to them. In that sheet *I want to export that data to access so that an individual can see his own data rather than seeing all. Any Ideas?????????? Thanks in Advance...- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I import from Access to Excel
Hi Carlo, Its 2000 version. I will post the questions if i have any.. Thanks a bunch... Cheers.. "carlo" wrote: Hi Srikanth Open your Access Database (Please tell me which Version it is). Go to your Database-wndow (F11) Go to Tables Rightclick on a blank spot and select "Link Tables..." The wizard should explain itself. If you still have questions, just post them here, or in the access database newsgroup cheers Carlo On Dec 27, 7:31 pm, Srikanth wrote: Carlo, Can you let me know how to link??? "carlo" wrote: If you need to transfer it once, you can just import it inte your acces database. Otherwise you could link your excel table. Does that help you? Carlo On Dec 27, 1:50 pm, Srikanth wrote: Hi All, I've a sheet which contains all my team members names and the work assigned to them. In that sheet I want to export that data to access so that an individual can see his own data rather than seeing all. Any Ideas?????????? Thanks in Advance...- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I import from Access to Excel
Carlo,
When I'm cilcking on link tables.. I cant see excel files i can seee only access files. Then how should i link them. Please help. "Srikanth" wrote: Hi Carlo, Its 2000 version. I will post the questions if i have any.. Thanks a bunch... Cheers.. "carlo" wrote: Hi Srikanth Open your Access Database (Please tell me which Version it is). Go to your Database-wndow (F11) Go to Tables Rightclick on a blank spot and select "Link Tables..." The wizard should explain itself. If you still have questions, just post them here, or in the access database newsgroup cheers Carlo On Dec 27, 7:31 pm, Srikanth wrote: Carlo, Can you let me know how to link??? "carlo" wrote: If you need to transfer it once, you can just import it inte your acces database. Otherwise you could link your excel table. Does that help you? Carlo On Dec 27, 1:50 pm, Srikanth wrote: Hi All, I've a sheet which contains all my team members names and the work assigned to them. In that sheet I want to export that data to access so that an individual can see his own data rather than seeing all. Any Ideas?????????? Thanks in Advance...- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I import from Access to Excel
On Dec 28 2007, 5:32*pm, Srikanth
wrote: Carlo, When I'm cilcking on link tables.. I cant see excel files i can seee only access files. Then how should i link them. Please help. "Srikanth" wrote: Hi Carlo, Its 2000 version. I will post the questions if i have any.. Thanks a bunch... Cheers.. "carlo" wrote: Hi Srikanth Open your Access Database (Please tell me which Version it is). Go to your Database-wndow (F11) Go to Tables Rightclick on a blank spot and select "Link Tables..." The wizard should explain itself. If you still have questions, just post them here, or in the access database newsgroup cheers Carlo On Dec 27, 7:31 pm, Srikanth wrote: Carlo, Can you let me know how to link??? "carlo" wrote: If you need to transfer it once, you can just import it inte your acces database. Otherwise you could link your excel table. Does that help you? Carlo On Dec 27, 1:50 pm, Srikanth wrote: Hi All, I've a sheet which contains all my team members names and the work assigned to them. In that sheet *I want to export that data to access so that an individual can see his own data rather than seeing all. Any Ideas?????????? Thanks in Advance...- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Hi Srikanth sorry for the late reply but i was away for a while. when you click link, you should make sure, that you select "files of type" as "xls" and not "mdb". hth Carlo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Access records into Excel | Excel Discussion (Misc queries) | |||
Excel file will not import to Access, what may be the cause | Excel Discussion (Misc queries) | |||
access query to import to excel | Excel Worksheet Functions | |||
Excel & Access Import Problems | Excel Discussion (Misc queries) | |||
Import Access into Excel | Excel Discussion (Misc queries) |