Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

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.OpenCurrentDatabase(Access_File_Path)
            appAccess.Visible = True

            appAccess.DoCmd.TransferText(TransferType:=Microsoft.Office.Interop.Access.AcTextTransferType.acImportDelim, TableName:=oTableName, _
            FileName:=oTextFilePath, HasFieldNames:=True)
0
Murray Brown
Asked:
Murray Brown
  • 7
  • 7
1 Solution
 
gowflowCommented:
So what you want to do ? Acceess or Excel ?

If Excel I could help you but need to know from you what do you want to achieve in plain English
gowflow
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi
I need to build the Access functionality used to define an import specification and I need to do this in Excel
0
 
gowflowCommented:
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
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
I don't appreciate your tone
0
 
gowflowCommented:
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
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks. I will think of a clearer way to pose the question
0
 
gowflowCommented:
ok will wait for your clarification.
gowflow
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi

A better way to ask this question is:
Is it possible to build the Excel form used to import a delimited text file
A simple yes or no answer will suffice
Any other advice will be a bonus

1
0
 
gowflowCommented:
Well for sure yes.
I can have you a small macro that can import any text file to Excel
just post the txt file or csv excel and will do that.
gowflow
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
0
 
gowflowCommented:
tks I just commented. You have to be careful, you said "just any text file" !!! just look at my comment there.
gowflow
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Ok Thanks
0
 
gowflowCommented:
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
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now