Solved

Excel Add-in Build Access Import Specification interface

Posted on 2013-12-05
14
434 Views
Last Modified: 2013-12-11
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
Comment
Question by:murbro
  • 7
  • 7
14 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39704395
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
 

Author Comment

by:murbro
ID: 39704542
Hi
I need to build the Access functionality used to define an import specification and I need to do this in Excel
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39704625
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
 

Author Comment

by:murbro
ID: 39704657
I don't appreciate your tone
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39704675
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
 

Author Comment

by:murbro
ID: 39704806
Thanks. I will think of a clearer way to pose the question
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39705540
ok will wait for your clarification.
gowflow
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:murbro
ID: 39711077
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
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39711120
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
 

Author Closing Comment

by:murbro
ID: 39711288
Thanks very much
0
 

Author Comment

by:murbro
ID: 39711292
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39711374
tks I just commented. You have to be careful, you said "just any text file" !!! just look at my comment there.
gowflow
0
 

Author Comment

by:murbro
ID: 39711430
Ok Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39711654
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now