Vba to retrieved data from excel and load it to my query (1 Viewer)

F

fluffyvampirekitten

New member

Local time

Today, 20:15

Joined

Aug 13, 2015

Messages

3

• Aug 13, 2015

• #1

Current situation is that I have this form with a chart.
Row Source :

Code:Copy to clipboard

SELECT PolyWrongRegInsCount.[INSTITUTION], PolyWrongRegInsCount.[NO_OF_GROUP]
FROM PolyWrongRegInsCount;

PolyWrongRegInsCount; <- This table is one of the queries that I created .

However, the data is manually added.
The problem is : I want to get the data from excel spreadsheet.
And load into my queries

Any idea on how to solve this ?
Thanks in advance

 

N

namliam

The Mailman - AWF VIP

Local time

Today, 14:15

Joined

Aug 11, 2003

Messages

11,695

• Aug 13, 2015

• #2

using Docmd.transferspreadsheet you can import excel sheets into your table.

 

F

fluffyvampirekitten

New member

Local time

Today, 20:15

Joined

Aug 13, 2015

Messages

3

• Aug 14, 2015

• #3

namliam said:

using Docmd.transferspreadsheet you can import excel sheets into your table.

Click to expand...

It worked! Thank you so much