473,883 Members | 2,819 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 #1
14 25197
32,584 Recognized Expert Moderator MVP
You're probably talking about the fact that they use '.' and ',' where we use ', and '.'. 500,000.00 would show as 500.000,00 over there, and in various countries in mainland Europe.

I don't know for sure, but you can try escaping the character in your use. You haven't shared that with us, I expect it's in your spec, but if you can, try "\," instead of ",".
Mar 12 '12 #2
CD Tom
492 Contributor
Ok, I'm sure you are correct in the way Europe uses the ',' and the '.' now here's where I show my ignorance I don't have a spec setup in the transfertext command. I have never set one up so I'm at a loss as to where to go. If you could point me the direction where I could find some information I would appreciate it.
Mar 12 '12 #3
32,584 Recognized Expert Moderator MVP
You set it up most easily by doing an import manually and saving the spec within that process.

In 2003 it's under File | Get External Data | Import...
Mar 12 '12 #4
CD Tom
492 Contributor
I was just looking at how to do this and I'm finding that Access 2007 doesn't give me the options to change any of the options. I see how to do it in Access 2003 but is there some way to do it in 2007? Sorry I should have mention 2007 in my earlier questions.
Again thanks.
Mar 12 '12 #5
32,584 Recognized Expert Moderator MVP
I expect so Tom, but I don't use 2007 (or even 2010 yet) so I can't direct you.
Mar 13 '12 #6
8,834 Recognized Expert Expert
This is how you Save a Specification in Access 2010, the process cannot be that far off from 2007.
  1. Click on External Data Tab.
  2. Under Import & Link, select Text File.
  3. Browse to your Text File, then OK.
  4. In the Import Text Wizard Dialog, select the Delimited Option.
  5. In this same Dialog, click on Advanced which Opens the Import Specification Dialog. Set your Import Options, then Click on Save As...
  6. Enter a Name for your Specification, then OK.
  7. Click on OK to Close the Import Specification Dialog.
  8. Click Next on the Import Text Wizard Dialog.
  9. Set other Options appropriately.
  10. When prompted to Save Import Steps, check Save import steps - this will enable you to bypass the Wizard next time.
  11. Click Save Import.
Mar 13 '12 #7
CD Tom
492 Contributor
I've tried the Specifications and was able to get into and tried to change the option to the "\," I put this in the decimal area because when I tried and put it in the text separator I would get an error message. However that didn't fix the problem, I've changed my computer settings to Netherlands(dut ch) to test this and I still get the error "Text file specification Field separator matches decimal separator or text delimiter" here's the exact statement :
Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferText acExportDelim, netherlandsspec, Vtable, apppathx, True
Thanks again
Mar 13 '12 #8
32,584 Recognized Expert Moderator MVP
I suspect you actually changed it to "Dutch (Netherlands)", after searching around aimlessly for the other :-D

Fortunately (or more likely unfortunately in this situation), when I ran mine it continued to behave exactly as it did using my normal settings - English (United Kingdom).
Mar 13 '12 #9
CD Tom
492 Contributor
Thanks again for all your help. I think I'll see if I can change the settings in the language setup on his computer. He is using this computer only to run this application and maybe changing to English(united Kingdom) on his will work.
Mar 13 '12 #10

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: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
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: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
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: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.