Excel Access
How can you fix an ambiguous error where excel and access are both using the DataTable class in C#?
I only need the DataTable class to use Access but it is also define in the using Excel statement that I need to input from Excel. The Compiler doesnt know which class I am refferencing
Fully qualify the DataTable class reference when you use it.
I assume you are usin the interop libraries to make calls to both Access and Excel. You probably have a using statement like
#using Excel;
#using Access;
Well, don’t use them. They contain common Office classes that conflict both with each other and the .Net classes. Instead just reference you Office classes as Excel.DataTable or Access.DataTable. It will work fine and be less confusing.
VBA/Excel Connecting Excel to Access using VBA