Lettronics Support

The place for free support for our software and systems.
Welcome to Lettronics Support Sign in | Join | Help
in Search

Help with editing stock in Access/Excel please

Last post 01-30-2013, 9:32 AM by Lettronics. 2 replies.
Sort Posts: Previous Next
  •  03-06-2010, 1:45 AM 1409

    Help with editing stock in Access/Excel please

    Hi there

     Please can anyone help me with entering stock in a table? Whats the best way to do it?

     In Access I cannot seem to add data and in Excel I connect fine to the DB but also cannot work out how to add data.... any ideas?

     

    Thanks in advance

  •  01-29-2013, 10:58 PM 1583 in reply to 1409

    Re: Help with editing stock in Access/Excel please

    Just noticed this post as being in the unanswered list.....

    Did you ever devise a system for entering the stock, or are you still using the  Invoices element of SCM?

     

     


    Dave
    Grantham Scout Shop
    www.grantham-scouts.org.uk
  •  01-30-2013, 9:32 AM 1584 in reply to 1583

    Re: Help with editing stock in Access/Excel please

    I'm afraid we still use SCM's Invoice section to enter in Stock.

    Whilst it should be possible to directly enter via Access or import (via Access, or via a directly connected data source in Excel), it would probably throw some of the reports out, as some will be looking at invoices.

    If this is not a problem, you are looking a bulk importing into the Products table, although you will have to maintain the links to Suppliers and Categories tables.


    Get free EPoS software at http://www.lettronics.com
View as RSS news feed in XML
Powered by Community Server (Personal Edition), by Telligent Systems