473,883 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Text file specification Field Separator Matches

492 Contributor
I have a customer in the Netherlands that is getting the following error "Text file specification Field separator matches decimal separator or text delimiter" This happens when I try and run the DoCmd.TransferT ext acExportDelim command. I know this has something to do with the settings on his computer regarding the separators. Is there any way that I can switch settings in my program to accommodate this. I'm probably not very clear on this but I don't know exactly what settings they use. Any help would be appreciated.
Mar 12 '12
14 25196
32,584 Recognized Expert Moderator MVP
That's a possible approach, and can certainly be used if all else fails, but my checking leads me to believe the fault lies in the spec itself. Unfortunately I don't have the database to check exactly what's what (nor could I even with a 2007 db), so it's your choice how far down that path you go before falling back to the Regional Settings solution.
Mar 13 '12 #11
CD Tom
492 Contributor
It seems like there are not a lot of options in the specs settings. I can only see the text delimiter and the decimal. If the text delimiter is a "," and the decimal is a "." if I change the decimal to a "," then the text delimiter is the same. My application is also in Australia and I haven't heard of any problems they are having. I might contact one of them and see how their computers are set.
Mar 13 '12 #12
32,584 Recognized Expert Moderator MVP
I must admit that I can see no obvious scope here either. I just know I'd explore it further if it were me working directly on the project. That's my own personal approach though, of course. There's no reason why you should feel the same way. We all work in our own ways, and I find that way is good for me.
Mar 13 '12 #13
CD Tom
492 Contributor
I'll probably keep looking at it but will not spend lots of time as this is only one case where I'm having this problem. Thanks for all the advise and help.
Mar 13 '12 #14
32,584 Recognized Expert Moderator MVP
No worries :-)

Glad to be able to.
Mar 13 '12 #15

Sign in to post your reply or Sign up for a free account.

Similar topics

by: E Arredondo | last post by:
Is there a way to create a MYSQL table or database using a text file that countains the Field name and the lenght ? that is : fields.txt ----- start ---------- name,10 address,15
by: ghadley_00 | last post by:
Hi, I have a MS access database into which I need to import a text file that is oriented vertically (fields are listed from top to bottom with the value for each field appearing to the right of the field name (with a "|" as a delimiter)). The text file will only have 1 record's data. I would ideally like to setup a linked table to import this data - does anyone know of a way I can setup this import? Any help that can be provided...
by: naiya | last post by:
i have to develop a VB application which reads the text from a .txt file, and i have to write the contents of the file to an Excel sheet. the format of the .txt file is name age company abc 23 xyz def 18 ghy ... and so on now when i load this data into an excel sheet, all diff information shouls appear in different cells of the excel...
by: Manish | last post by:
The project I am developing doesn't involves database. I want to parse the mailbox file (.mbx) and store the summary in the text file for fast retrieval and display of information in the Inbox page. The sugegsted format are as: #1 ID : Subject : To Address: From Address...etc...
by: NEWSGROUPS | last post by:
I have data in a table in an Access 2000 database that needs to be exported to a formatted text file. For instance, the first field is an account number that is formatted in the table as text and is 8 characters long. This field needs to be exported as pic(15) padded in the front with 0's (zeros). The next field an ID name that is 15 characters that needs to be exported as pic(20) padded with trailing spaces. There are about 5 fields in...
by: 5095 | last post by:
Hi, i want to import data in multiple tables from a single text file (each field is seprated by pipe sign and each record is seprated by asterisk * ). Please guide me to the appropriate way. Regards
by: angelasg | last post by:
Hello. I am saving an Excel file as a text file then importing it into Access using a specification. One of the fields in the file is a currency formatted with commas. Those numbers over 999 are being interpreted as text and not imported. I could modify the Excel file not to use the commas before I import, but I was looking for something more automated. I tried making it a text field in the specification, but it still only
by: grant | last post by:
I have a transfer data task that gets some data from a table and outputs it to a pipe delimitd text file. How can I configure a transfer data task so it outputs the field names from the table in the first line of the output file Thanks in advance Grant
by: iheartvba | last post by:
Hi I am using Access 2007 and am trying to export a query to a fixed length text file. I tried using the following code to export the text file: DoCmd.TransferText acExportFixed, , "qryFFRDeFile", "C:\qryFFRDeFile.txt", True Access asks for a specification name, now here lies the challenge, how do I create an export specification I have tried the following 2 methods: In access 2007: Step1: I right clicked the query and chose export to...
by: mabrynda | last post by:
Dear Experts, I have the following problem. I'm generating output txt files from access (an access 2002 table is converted into deleimited text with tabs including field names). For that I have a small function that I call from the main VBA script, which includes the so-called Export Specification. Everything works fine as long as the name of the output file is written in characters in the file specification of the DoCmd.TransferText command. ...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.