none
MS Access 2016 Import RRS feed

  • Question

  • Hello All,

    I can't find an answer.

    I would like to import into MS Access data between 2 tables.

    [SELECT Manufacturers.[ID], Manufacturers.[Company Name] FROM Manufacturers WHERE Manufacturers.[Company Name] = Import.Manufacturer0] This doesn't work, why ?

    In my Assets DB Manufacturer is Numeric as it's an ID

    In my Import DB Manufacturer is Text "HP"

    I would like to say, look in my Manufacturers DB to copy the ID.

    INSERT INTO Assets (Hostname, Manufacturer, Status)
    SELECT Import.Name011, [SELECT Manufacturers.[ID], Manufacturers.[Company Name] FROM Manufacturers WHERE Manufacturers.[Company Name] = Import.Manufacturer0], 2
    FROM Import
    WHERE Import.ID = 1; 

    Many thanks in advance.

    Johann

    Friday, January 11, 2019 1:55 PM

All replies

  • Hi Johann,

    To better fix the issue, I would move the thread to Access forum for more suggestion. Thanks for your understanding.


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact: tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Monday, January 14, 2019 7:13 AM