Most businesses these days use Microsoft Excel Spreadsheets in one fashion or another. Given there are a variety of uses for spreadsheets to read, review and manipulate your data, it is hard to see how using this tool could limit your business.
Read More >3 Key Areas Spreadsheets May Be Limiting Your Growth
By
Hayley Kornilenko | Aug 26, 2020 3:29:00 PM
Importing Transactions Using Power of MS Query
By
BAASS Consultant | Mar 5, 2010 12:00:00 AM
Sometimes one doesn't have to exit an Excel spreadsheet to get the necessary data. All Sage 300 (formerly Accpac) tables can be accessed and analysed directly from within Excel. Yes, yes - Excel! I'm talking here about MS Query that can be called upon from the Data menu of Excel. Provided you know the ODBC connections to your company's data and credentials to access it you're good to go and query the data you need, all fields of any table, with the availability of selections and filters. Of course knowing SQL language can be handy and can save hours of work, as in the below example.
Read More >Subscribe Here!
POSTS BY SOLUTION
- CRM (51)
- ERP (49)
- BI (42)
- Tips & Tricks (37)
- Cloud (32)
- HRIS (26)
- Baass Connect (23)
- Error Message (15)
- Payroll (14)
- WMS (13)
- Manufacturing (11)
- Business Intelligence (10)
- Sage 300 ERP (10)
- Sage Tips (10)
- Sage CRM (9)
- BAASS News (8)
- Cloud Computing (7)
- Intacct (7)
- Inventory (7)
- Sage 300 (7)
- Baass Business Solutions (6)
- Service Management (6)
- Development (5)
- Fixed assets (5)
- Security (5)
- Work From Home (5)
- data management (5)
- remote working (5)
- Sage ERP (4)
- cloud solution (4)
- Cloud ERP (3)
- Cloud Security (3)
- ERP system (3)
- Sage Payroll (3)
- Supply Chain Software (3)
- financial data (3)
- project management (3)
- Accounting Software (2)
- Budgeting (2)
- Business General (2)
- Canadian Payroll (2)
- Cloud Accounting (2)
- Cloud Hosting (2)
- Crystal Reporting (2)
- Customer Relationship Management (2)
- Excel (2)
- Fixed Fee Pricing (2)
- Forecasting (2)
- Legislation (2)
- Mining (2)
- Productivity (2)
- Reporting (2)
- Sage FAS (2)
- Sage HRMS (2)
- Sage HRMS Payroll (2)
- Senior Living (2)
- Success Story (2)
- business forecasting (2)
- inventory management (2)
- tips (2)
- womenintech (2)
- Accounts Payable (1)
- Accpac (1)
- Avalara (1)
- BI Software (1)
- BI Tools (1)
- Barcoding (1)
- Benefits of Cloud Computing (1)
- CRA (1)
- CRM system (1)
- Cloud Services (1)
- Credit Card Payments (1)
- Credit Card Processing (1)
- Digital Transformation (1)
- Document Management (1)
- EDI (1)
- ERP Cloud (1)
- ERP Consultant (1)
- ERP Software Failure (1)
- ERP solution (1)
- FAS (1)
- Global Business (1)
- Multi Entity (1)
- Operational and Financial Information Systems (1)
- Order constraints (1)
- Outgrown QuickBooks (1)
- PST in BC (1)
- Plus Computer Solutions (1)
- RRSP (1)
- Sage 300 Payroll (1)
- Sage BI (1)
- Sage Business Partner (1)
- Sage Enterprise Intelligence (1)
- Sage Intacct (1)
- Sage Intelligence (1)
- Sage Inventory Advisor (1)
- Sage Software (1)
- Senior Living Facility (1)
- T4 (1)
- The Cloud (1)
- accounting management software (1)
- accounting software system (1)
- cloud based solution (1)
- conference (1)
- data (1)
- data backup (1)
- efficiency (1)
- employee self service (1)
- myths (1)
- planning (1)
- solution (1)
- technology (1)
- training (1)