I dont have permission to create table on server but when I tried to create temp table it got created.
Create table polist (PO nvarchar(20))
insert into #polist values ('4022742493')
select * from #polist
I want that table in MS access so that I could append all my POs in temp table but I dont know where it got created. Even When I run pass through query in access it give me error that invalid object. When I run it on sql it shows me one po.
where I am doing wrong.