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

Access Text Import Wizard Error

We have a text file that we import into an Access table each month, with no problems. We recently migrated to a new level of SAP. Now when I generate this same text file in SAP; I get an error when I try to import it to the same Access table. I get the message "Property not Found".How can we resolve this issue and import this file?

0
Orange-County-Joe
Asked:
Orange-County-Joe
1 Solution
 
Neil RussellTechnical Development LeadCommented:
Compare the text file against a version created in the prior version of SAP, you do keep a backup of the old imports, right?
Unless you have changed the Access database code or tables as well at the same time then that is where the error lies.
Compare total number of fields in each line for a start. Is the column layout and order EXACTLY the same?
 
0
 
hs290181Commented:
Can you share your file with test data?
Their might be some date-time related issues.

0
 
Orange-County-JoeAuthor Commented:
Thank you both. I pulled last months file into our Table in Access. And I puled this months file into a new table in access; with no predetermined fields or data types etc. Then I compared the tables one above the other. In the NEW file all fields have thier data AND a space with an "A" with an "^" accent above it. And of course blank fields have the "A" with the accent. There may be an issue with us having dropped some criteria in our variant. Here is a snapshot of our two files.
  Any Ideas on how we can crerate a new file without the extra "A" and accent in every field?



Bad-Text-File-ZRSM06.doc
0
 
Jeffrey CoachmanMIS LiasonCommented:
It looks like SAP added quite a bit of changes to this format...
Not sure what the "A" characters stand for...

In any event, the biggest issue is that the new file has no field names.

You need to contact SAP and ask how this same data can be exported as a standard text file.

JeffCoachman
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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