?
Solved

Access export error

Posted on 2013-02-05
3
Medium Priority
?
272 Views
Last Modified: 2013-02-19
Hello,
     I have a form that is tied to a query.  The form is used to enter dates.  I have it setup to export to a text file.  I run the identical form and query on several databases with no errors except for one throws an error.  I have attached a screenshot.  IT still will export to the txt file but deletes a bunch of data.
Capture.JPG
0
Comment
Question by:aplona
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 26

Expert Comment

by:jerryb30
ID: 38856464
This looks more like an import error.
Can you post a sample db?
0
 
LVL 48

Accepted Solution

by:
Dale Fye earned 750 total points
ID: 38856481
Looks like the datatypes of the fields in your SELECT statement, don't match the field types of the fields you are trying to insert into.  Make sure that the fields are lined up in the same sequence in the field list and in the SELECT statement.

Can you post the SQL
0
 
LVL 48

Expert Comment

by:Dale Fye
ID: 38906779
aplona,

Why the "B" grade?
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

650 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