Search results

The only two reasons we would need to use Excel is to import it to Access because that's how we download the bank statement and when we are finished with Access and export it to Excel to import it to our accounting software. Excel is the only program that is compatible to our accounting software...

Yes, I would want to use all 3 different softwares. Right now, we only use excel and our accounting software. In excel, we have a spreadsheet for the upload. It isn't ideal, we are copying/pasting the bank statement to the spreadsheet and have 4 columns of IF/Then Statements to label the...

I am starting to work on a cash database and I am in looking for some guidance on the best way to start this task. The goal of the database is to take the transactions from an excel version bank statement (Payroll & Operating) and run them through Access to give them a specific AU/Account and...

New member to the site. I am looking forward in working with all of you. I am a staff accountant at a nonprofit hospital in Minnesota. I am trying to learn more about access to help me improve my work tasks.