Software

Ask something
Discussion Locked

Import XML into Access w/ # in filename

0 helpful
2 replies

by techsupportspecialist 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have an application that generates XML documents that need to be imported into Access. Most of these XML documents typically have a '#' character in the filename (example: Jones#49.xml).

For some reason, Access will not import these, but the documentation does not indicate that a # character is a problem. We can get around this problem by renaming the file without the # character, but this is a burden for our users. They need to be able to import the xml files as they are.

1) Can anyone tell me why Access won't import xml documents with a # sign? (There doesn't seem to be any documentation that talks about this problem.)

2) Is there anyway to fix this problem without renaming the file?

All attempted responses will be appreciated. Thank you.

2 replies

by riverfreight

The pound sign is a Basic Language command at the least and somewhere your clients are going thru a mainframe and it is translating inmto that language and then back to DOS for yours and ....

Is there any way to fix the problem: Go to Properties and get up digittal and turn it off; now if you can do this in regard to only a customer or a parameter violtion reaction I don't know.

RIVER FREIGHT

This discussion is closed to new replies.