Populating Spreadsheet control in Access

[lblMyName]

Hi, I am new to access XP. Pls. can someone tell me how can a spreadsheet control on an access form be linked to a table for retrieving data onto it. I tried export/import with a .csv/txt file but can there be a better way? Thanks in advance.

 

[aleb]

If you are using this control to input or display the data in excell then you need to insert another cotrol ( Microsoft Web-browser object ) instead of your current control and display excell in it.

if not then you go to file>get external data>Link tables
Select from the "Files of type" Microsoft excell and link the file. Base a form on the linked table now.

 

[lblMyName]

If you are using this control to input or display the data in excell then you need to insert another cotrol ( Microsoft Web-browser object ) instead of your current control and display excell in it.

if not then you go to file>get external data>Link tables
Select from the "Files of type" Microsoft excell and link the file. Base a form on the linked table now.

Thanks Aleb for help. Can you pls elaborate it more for me to understand it fully.
I am not using excel file with my access database. I just want to fill up the values from say 20 records from three fields of a table (within the same database of course) in 20 rows and 3 columns of an "access spreadsheet" control (Not from excel!). Therefore the problem is how to specify the data-source of this control as this table? So that when I open this control on a form, it automatically loads data from the table for further processing.
Thanks again and my best regards,

 

[aleb]

Oh I see ... you want to specify the record source for your form
The easiest way of doing it is to use the "Create form using wizard" on the "Forms" tab in access. Launch it and follow the steps.

for you information I've also attached the example of my previous reply.
Unzip both files to your C:\

 

[lblMyName]

Thanks a lot aleb for the prompt reply, will try this.