Murray Brown
asked on
Excel Add-in Build Access Import Specification interface
Hi
I have an Excel ad-in that handles a large amount of incoming text files into
Access, The following code works fine most of the time, but there are instances where the user needs to actually build an import specification as you would in Access.
Is there something that exists in VB.net already? I realise that that is unlikely so I am looking for a little guidance either on building my own. Alternatively, is there a way to manually pull the file into Excel and somehow use this?
appAccess.OpenCurrentDatab ase(Access _File_Path )
appAccess.Visible = True
appAccess.DoCmd.TransferTe xt(Transfe rType:=Mic rosoft.Off ice.Intero p.Access.A cTextTrans ferType.ac ImportDeli m, TableName:=oTableName, _
FileName:=oTextFilePath, HasFieldNames:=True)
I have an Excel ad-in that handles a large amount of incoming text files into
Access, The following code works fine most of the time, but there are instances where the user needs to actually build an import specification as you would in Access.
Is there something that exists in VB.net already? I realise that that is unlikely so I am looking for a little guidance either on building my own. Alternatively, is there a way to manually pull the file into Excel and somehow use this?
appAccess.OpenCurrentDatab
appAccess.Visible = True
appAccess.DoCmd.TransferTe
FileName:=oTextFilePath, HasFieldNames:=True)
ASKER
Hi
I need to build the Access functionality used to define an import specification and I need to do this in Excel
I need to build the Access functionality used to define an import specification and I need to do this in Excel
I said plain English ...
meaning I need to import from access databse name so and so table xys all records into eXcel in sheet so and so starting row xyz in col abc ...
something along these lines specifics not access instructions !!!
btw if you noticed no one answered or gave any reply to your question this should give you a hint !!!
gowflow
meaning I need to import from access databse name so and so table xys all records into eXcel in sheet so and so starting row xyz in col abc ...
something along these lines specifics not access instructions !!!
btw if you noticed no one answered or gave any reply to your question this should give you a hint !!!
gowflow
ASKER
I don't appreciate your tone
Sorry if it sounded arrogant but not too expert in Access systax but can help you as much as you want in Excel. I only need to know what you want so I can do it for you. Sorry if sounded aggressive was not the intention at all.
gowflow
gowflow
ASKER
Thanks. I will think of a clearer way to pose the question
ok will wait for your clarification.
gowflow
gowflow
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much
ASKER
Hi. Please see this further related question
https://www.experts-exchange.com/questions/28315692/Excel-VBA-macro-that-can-import-any-text-file-to-Excel.html
https://www.experts-exchange.com/questions/28315692/Excel-VBA-macro-that-can-import-any-text-file-to-Excel.html
tks I just commented. You have to be careful, you said "just any text file" !!! just look at my comment there.
gowflow
gowflow
ASKER
Ok Thanks
Thanks your kind but it didn't deserve that many points for my comment. Just wanted to draw your attention. If the other Expert object I have no problem at all he deserves the full 500 pnts !!
gowflow
gowflow
If Excel I could help you but need to know from you what do you want to achieve in plain English
gowflow