Okay so I know this isn't a question for MS Access, but this is as close as I could find for Excel. So here's my question:
I have 2 pages set up with data pulling from one to populate the other. That formula works without an issue, but one formula seems to be kicking my butt. I need it to read a date on one page and when you put in that specific date it will then populate pre-filled data onto the first sheet. For example the second...
4 results in 0.0044 seconds.
-
Microsoft Excel 2007
-
How to import an Excel Spreadsheet without specific column(s)?
Hi All,
I am using the following code to import a spreadsheet into my Access 2003 tblWeekly table:
The strOutFile contains the path and file name of the spreadsheet. The "impData" is the range that contains the data I need to import. It is a fluid range (changes from week to week)....Code:DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tblweekly", strOutFile, True, "impData"
-
What is best way to integrate spreadsheets into an access database?
I have some spreadsheets that are external to my database, and i'm working on trying to have everything we need to do integrated into the database.
I have tried using the Microsoft Office Spreadsheet ActiveX Control, it will display the spreadsheet (once converted to an XML spreadsheet) in the form but you cant save back to the file.
I have tried adding it as an OLE object, which displays it then when you double click... -
Microsoft Office Spreadsheet 11.0 ActiveX Control
I want to use the Microsoft Office Spreadsheet 11.0 ActiveX Control on my form so that I can view and edit a spreadsheet inside the form as if there was a mini excel window in there.
I converted the .xsl to a XML spreadsheet as this control only lets you import CSV, XML, or HTML pages.
Everything shows up fine, but is there a way to save back to the file? Seems like it can only read the file and update the form with...
