Advertisement

07.11.2004 at 06:16AM PDT, ID: 21054705
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

Import Text File into MSAccess database using SQL command

Tags: access, import, file, text, sql
Greetings,
I am developing a Delphi apllication and need to import both CSV (comma separated) and SDF (fixed lenght) files into an Access database.

Lets say that the Access database is DB1.MDB with a table TABLE1 and the text file IMPORT.TXT

All I need is the correct syntax of the SQL command that I think it should start like INSERT INTO...but I lack the knowledge of the remaining code

To import the same file from an Access table like TABLE2 on a Database IMPORT.MDB is easy:
INSERT INTO DB1.TABLE1 SELECT * FROM IMPORT.TABLE2

But I want to import from a Text file either CSV or SDF

Please Help
Start your free trial to view this solution
Question Stats
Zone: Microsoft
Question Asked By: blucaster
Solution Provided By: dkmj17
Participating Experts: 5
Solution Grade: B
Views: 353
Translate:
Loading Advertisement...
07.11.2004 at 09:42AM PDT, ID: 11523766

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
07.11.2004 at 09:51AM PDT, ID: 11523804

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
07.11.2004 at 09:55AM PDT, ID: 11523818

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
07.11.2004 at 10:28AM PDT, ID: 11523991

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
07.11.2004 at 10:36AM PDT, ID: 11524037

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
07.11.2004 at 11:11AM PDT, ID: 11524165

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
07.11.2004 at 11:37AM PDT, ID: 11524311

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
07.11.2004 at 11:57AM PDT, ID: 11524400

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
07.12.2004 at 07:07AM PDT, ID: 11529185

Rank: Genius

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.09.2004 at 09:49PM PDT, ID: 11759578

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.12.2004 at 12:21PM PDT, ID: 11787346

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
08.12.2004 at 12:48PM PDT, ID: 11787639

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080236-EE-VQP-29