Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copy/Pasting into flexgrid
- Thread starter Yazster
- Start date
There is a way to transfer the items in an excel spreadsheet into a flexgrid. You can return the column as a recordset (using ADO or DAO), then use the FlexGrid.TextMatrix property to write the values in. You may also be able to read the excel spreadsheet with FileSystemObject, but ADO is probably a better choice.
Since this is a little more involved than Cntrl+C and Cntrl+V, let me know if you need more details on how to read the excel spreadsheet or how to write to the flexgrid.
Since this is a little more involved than Cntrl+C and Cntrl+V, let me know if you need more details on how to read the excel spreadsheet or how to write to the flexgrid.
- Status
Similar threads
- Locked
- Question
