Can you add data to a linked excel table

[Sonyat810]

I have a linked table and a form. But I dont see where you can add data to the linked table

[Minty]

Not directly as a linked table.
However have a read here :
https://www.access-programmers.co.uk...access.322079/

[June7]

I tried the query and can't get past "Syntax error in FROM clause". And yes, I changed the file path and sheet name.

[CJ_London]

can't get past "Syntax error in FROM clause".

what is your sql?

[isladogs]

Not directly as a linked table.
However have a read here :
https://www.access-programmers.co.uk...access.322079/

As my post at AWF explains, you CAN directly edit a linked Excel table by changing the IMEX settings from the default IMEX=2 (read only) to IMEX=0 (editable)

[June7]

Query from tutorial with my sheet name and file path:

SELECT XL.*
FROM (SELECT * FROM [Units$] AS xlData IN 'C:\Users\Owner\June\MyStuff\Condos.xlsx'
[Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes]) AS XL;

[CJ_London]

trying to determine which FROM is causing the issue as the syntax works fine for me - what if your try removing the alias? - and is Units the name of a worksheet or a range?

SELECT * FROM [Units$] AS xlData IN 'C:\Users\Owner\June\MyStuff\Condos.xlsx'
[Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes]

[isladogs]

Query from tutorial with my sheet name and file path:

SELECT XL.*
FROM (SELECT * FROM [Units$] AS xlData IN 'C:\Users\Owner\June\MyStuff\Condos.xlsx'
[Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes]) AS XL;

Whilst that code should work, the easier method is to link the Excel file as a linked table.
If you do that, there is no need to run an external query

Try using the example app included in the web version of my article: Edit Linked Excel Data from Access (isladogs.co.uk)

[Welshgasman]

SELECT * FROM [Stock$] AS xlData IN 'F:\Users\Paul\Documents\Stock Quotes.xls'
[Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes]


SELECT XL.*
FROM (SELECT * FROM [Stock$] AS xlData IN 'F:\Users\Paul\Documents\Stock Quotes.xls'
[Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes]) AS XL;

Either works for me.

Thank you.

[isladogs]

I have a linked table and a form. But I dont see where you can add data to the linked table

I have edited the connection string to make the linked Excel file editable in Access
However, as you didn't supply the linked Excel file, I can't test whether that setting will 'stick' for you

[June7]

VBA changing connection string of linked sheet did work.

And crud. I deleted the worksheet link, copy/pasted my SQL from post 8 and tried the query again. Now it opens without error. Bizarre!