Hi all,

I have an Access DB with hundres of queries and reports, now I have to use an external DB (Oracle) and export data keeping the rest, no problem with that, I have added linked tables through odbc and works fine.

My problem is that some of the tables have field names with spaces, and Oracle doesn't admit them. Does anybody knows how to solve it without having to modify all the queries, etc?, I've been thinking about aliases or views over the linked table but I haven't found a way to create these.

Any help?

Thanks

cant you put them in square brackets like access

eg

[my field]

No, ORACLE is not happy with that.

Search this forum for articles referencing a "global edit" function. That might help. But it has been too long since I saw it so all I can do is report that it exists.