Populate Form with Data from Excel Spreadsheet

[karmahum]

Hello.

I currently have a data-entry form that users fill-out with data (duh!). The data comes an excel spreadsheet that is created during the work-flow process.

I would like to add an "Import" button the field that, when clicked, would prompt the user to select a spreadsheet (different each time) and once that was selected import data into the form (and ultimately the table). The data will always be in the same location (cells and sheet) within every speadsheet.

Any ideas?

Thanks in advance.

Sean

 

[dan-cat]

Totally lazy answer but why not link the spreadsheet via link tables?

 

[karmahum]

The underlying spreadsheet...

changes. It will never be the same.

 

[dan-cat]

Here's a good example of how to programmatically create a link to an external file.

http://www.access-programmers.co.uk/forums/showthread.php?t=63235&highlight=back+end

 

[karmahum]

Thanks...But,

I am not looking to create a link. I am looking to populate the form with the data and save it to the underlying table. I am looking for a import rather than a link.

 

[Paulsburbon]

I'm looking for the same

I'm trying to do the same. Thanks.

 

[Mile-O]

Two things to do:

• Use the Windows API to open the Windows Common Dialog;
• Use the TransferSpreadsheet method.