• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

Access export error

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
aplona
Asked:
aplona
  • 2
1 Solution
 
jerryb30Commented:
This looks more like an import error.
Can you post a sample db?
0
 
Dale FyeCommented:
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
 
Dale FyeCommented:
aplona,

Why the "B" grade?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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