Solved

Use a SQL statement to import text files

Posted on 2007-11-15
4
177 Views
Last Modified: 2010-03-20
I am currently using 'DoCmd.TransferText' to import text files using the import specifications to bring the text files into a table.  Is there a way to import text files without using the DoCmd function?
0
Comment
Question by:TBayXXXV
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 20289591
You could write your own file handler in VBA using the filesystemobject.

Why is transfertext a problem?
0
 

Author Comment

by:TBayXXXV
ID: 20289621
In the future, the code is going to get converted to .net and I'm told that .net doesn't support the DoCmd function.  I was asked to look for an alternative.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 125 total points
ID: 20289762
.net doesn't look anything like vba.
Nothing you write will convert to .net.


0
 

Author Comment

by:TBayXXXV
ID: 20290007
I see.  Ok, thanks.
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

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…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

829 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