INSERT INTO Table from another access table

[pedie]

Hi, "INSERT INTO Table from another access table" - Is it possible to select all into this databse table from another database table?

I show something like this...but wont work [dont know how to make it work...]

[/FONT]
[FONT=Courier New]Sub Test1()
Dim SQL As String[/FONT]
[FONT=Courier New]SQL = "INSERT INTO ACCESSTBi ( NAMES )" & " " & "IN 'E:\Access\Database4.accdb' "
SQL = SQL & "SELECT ACCESSTBi.NAMES "
SQL = SQL & " FROM ACCESSTB;"[/FONT]
[FONT=Courier New]CurrentDb.Execute SQL[/FONT]
[FONT=Courier New]End Sub

Thanks in advance for helping.

 

[Norie]

Pedie

What do you mean by 'select all' and how does the code you posted not work?

By the way, are the tables actually in different databases?

If they are then why not just import/link the table the data is coming from?

Then you could do this manually.

 

[pedie]

Pedie

What do you mean by 'select all' and how does the code you posted not work?

By the way, are the tables actually in different databases?

If they are then why not just import/link the table the data is coming from?

Then you could do this manually.

Norie, thanks for quick response. For some reason i want to select all data into my table in frontend. Linking data will lead to some problem like data reaching some users who are not suppose to see it etc...So i want to select all when open and delete all when form is unloaded.

 

[Norie]

Pedie

How is it possible for data to reach someone it shouldn't?

Don't you have any restrictions setup on who can access data?

Also, what's the difference between using code to get all the data and creating a link, which would also involve all the data?