QUESTION : I have an inventory spreadsheet that contains a table of records imported from a Microsoft Access database. To […]
Tag: microsoft-access
How can I extract specified values from a string in excel document? [closed]
QUESTION : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Split data in half evenly by adding column with value: 1 or 2 based on specific cell value – excel
QUESTION : I have a query I pulled from a database with student information. The table has the following columns: […]
Excel: How to set up data for Feedback Analysis
QUESTION : I’d greatly appreciate any help on how to set up data correctly in Excel for this analysis (excel […]
Change SystemDSN to FileDSN for 100’s of MS Access and Excel Files
QUESTION : A particular team in my office uses 100’s of Microsoft Access Models. They all connect with the database […]
can I run a split ms access database on a linux server?
Problem : An ms access database has been split so that the back end of it is on a windows […]
Is there an equivalent of Excel’s DATE() function in Access 2007? [closed]
QUESTION : It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or […]
Excel 2003 to Excel 2007 performance on large files
QUESTION : We have a user that uses Excel 2003 for a few of their acturial formulae. At the moment […]
Two Access fields into Word without delimitation
QUESTION : I have two fields in Access, FN and LN that need to be converted to word without being […]
Combining two Excel sheets
QUESTION : I ship a lot of items to a lot of stores and I have two Excel sheets. I […]