Hi All,
Im having a bit of problem importing a text file into my database. The database is split into two (FE and BE). The code WAS working fine - however has now stopped working throwing up the errors below.
The bit of code causing the problem is:
DoCmd.TransferText acImportDelim, , "tbl_TEMP_Import", FileLength, True
FileLength contains the path to the file, and tbl_TEMP_Import is the table it needs importing into.
The error I am getting is one of two, either:
1) Numeric Field Overflow 3349
2) Cant remember the exact details but was something like "Property Not Found".
Any ideas? As I said, the code was working fine, I've tried and compact and repair and its not sorted it.
Thanks, Shane
4 2900
...
DoCmd.TransferText acImportDelim, , "tbl_TEMP_Import", FileLength, True
...The error I am getting is one of two, either:
1) Numeric Field Overflow 3349
2) Cant remember the exact details but was something like "Property Not Found".
Hi. I notice that you are not using a file import specification; a potential source of the error is an imported field treated as a numeric, say, which contains a text value or other non-numeric value part way into the import. This will cause errors as a result of non-compatibility of the data. Without an import specification Access will interpret the data types from the first lines it encounters.
I have quoted the TransferText help file note on the import specification below: SpecificationName Optional Variant. A string expression that's the name of an import or export specification you've created and saved in the current database. For a fixed-width text file, you must either specify an argument or use a schema.ini file, which must be stored in the same folder as the imported, linked, or exported text file. To create a schema file, you can use the text import/export wizard to create the file. For delimited text files and Microsoft Word mail merge data files, you can leave this argument blank to select the default import/export specifications.
-Stewart
Thanks Stuart - I will take a look at that and see if it fixes it.
Thanks, Shane
Tried this but still getting the same error. I have tried looking around on the net and a few other people seem to get the problem after splitting the database in 2 but nobody seems to know a solution.
Anybody got any ideas?
Sorted it - as it turned out the file I was trying to import had changed slightly. Fixed it, thanks again for your help Stewart.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Sue |
last post by:
Using WindowsXP and AccessXP in 2000 Mode
When I run the following code, I get error 3027
"Cannot Update. Database or object is read only."
StrFolder = "C:\Comic Box\WebStore Interface...
|
by: BigData |
last post by:
I am attempting to create a delimited text file by using
DoCmd.Transfertext as shown here.
DoCmd.TransferText acExportDelim, "ExportSpec", "QryFinalExport",
"Fileout.txt"
This works fine as...
|
by: Vladislav Moltchanov |
last post by:
I have discovered a couple of years ago, that import with
DoCMD.TransferText for CSV text file doesn’t work in Acc2000, while it
works perfectly in ACC97.
which has been discussed on this...
|
by: Shyguy |
last post by:
I need to import a text file pretty much daily. I download the file
and change the name to a standard name and then run the code to import
the file into a table in my database. The problem is...
|
by: Typehigh |
last post by:
I am a pretty saavy user, but I am having a real problem with the
DoCmd.TransferText operation.
I manually used the File>Get External Data> Import routine to set up an
import specification. It...
| |
by: axelleforever |
last post by:
Bonjour,
La première colonne de mon fichier texte (séparateur points-virgules)
contient des valeurs alphanumériques (1,2a,3u etc). Je constate que
seules les valeurs numériques sont importées...
|
by: holdemfoldem |
last post by:
Hi. I'm new to this board and have a few questions about using the
method referred to in the topic of this message.
I have manually transferred over 1/2 million records from a text file
into my...
|
by: Richard Beacroft |
last post by:
Trying to write a C# Windows App to export all objects and content from
2 MSAccess 97 databases for comparison analysis.
very little documentation found.
Have managed to instantiate MSAccess,...
|
by: matchine |
last post by:
This is a recommendation based on my research on an issue with the
transfer text functionality. The comments below were from a tech I
approched for help.
"The transfer text process blocked...
|
by: Tim Marshall |
last post by:
IN trying to export a Jet query (an actual saved Jet querydef which is
written against a pass through query - not that that should be a
problem) to text via either the File->Export... menu item or...
|
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,...
| |
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |