MS Access 2016 Import

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

Answer 1

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： [e-mail].

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