Save a Excel spreadsheet in an Access table as an Ole-Object using RRS feed

  • Question

  • how can I do the above - so that I can use the spreadsheets in the reportgenerator i Access


    Im using 2.0 and Access 2003


    I would be glad for your help 'Sisyfos'

    Monday, March 17, 2008 11:33 AM

All replies

  • I would suggest to store files information inside of database as a path, not as a content. First of all, if you store files as BLOB content, your database will grow very fast and you could easily reach the limit of Access database size. Second, you would need to compress your database frequently, because Access will use lots of temporary space during insert of BLOB data.


    Tuesday, March 18, 2008 9:42 AM