Hello,
I am a beginner and installing Visual Studio.net Enterprise edition.
I would like to know if .net will help me to the following.
I wish to import an Excel file to Access creating a table(List1)
overwriting the old List1, execute the saved query, overwrite the Output table (or delete the existing Output table),and export the Output table to Excel across a LAN to a user directory.Can this all be accomplished using VBA in .net?
Thank you.
Joe

VBA or .NET?

(Actually, it doesn't matter viz your question.)

The answer is “Yes,” if you have permission to access the files and folders involved.

HI Brian, Thank you for your reply. It would be .net I am using.
I am a rank beginner, sorry if my question wasn't good.
How would one begin to do this?
Thanks,
Joe

You have a lot to learn...
You should learn how ADO.net works, first of all.
There are several objects involved (Datasets, Data Adapters, etc.).
You're probably going to have to make some incremental inroads with such tasks as how to open the source files involved (writing a small project to explore how that's done), and also how to send data to the files involved.

Getting a beginning book on .NET would be good, then sit down and read it with a cup of coffee. .NET is much more robust than VB 6; It will take effort.
(I don't mean to lecture. I'm only saying "you have asked a mouthful!")

Hi Brian,
You bet. I do have a lot to learn. I do not have ADO.net and am concened. I was only given Visual Studio.net Enterprise edition.
I do have some experience outside of the Microsoft framework regarding object adapters(from CORBA). This pprbably won't help. I appreciate your suggestion. Thank you.
Joe

ADO.NET is included with VB.NET. This is the database functionality of choice with .NET.

You set a reference to it, and its functionality becomes part of your project.
THe Help that Enterprise edition comes with should be enough to get you going on this; there is a lot there.

Hi Brian,
Again thank you for pointing me in the right direction.
I will gain familiarity with ADO.net
Joe