I'm supposed to import data from an Oracle database and insert into several Access databases.
My BIG problem is that Access doesn't show more than 256 columns!!!
It seems it doesn't support more than 256 columns at all...
The table that I'm supposed to import from has 328 columns! And no it can't be redesigned... Even if I know the columnname Access doesn't work..
Is there any way around this? I have a SQL Server database that I figured I could use but I'm not allowed to have a linked server in it so I can't link to the tables in the Accessdatabases and the Accessdatabases can't link to SQL-server because there are other accessdatabases that are linked to these tables and links to linked tables are not allowed!
In access you can send querys to oracle using pass-thruogh querys.
Create a new query, dont add any tables...
Now in the menu, click Query=>SQL Specific=> Pass-through query
Note: you are now in SQL view in the query builder
If you get the properties (right click the title bar of the query, select properties)
you can set all kinds off things, including the connection string (which you can steal/copy of you linked tables).
Thus you will not need to use linked tables at all and you can pick and choose what field you want in the query from what table.... even linking the data and stuff...