473,554 Members | 2,829 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Missed the Boat on Import Logic

I guess I missed the boat on the logic for this one. Immediately upon
hitting "Import" in an
attempt to import an Excel file containing 7 columns of 'txt' formatted data
into AXP, I got a "Type mismatch" error. A search of previous posts
indicated that Access did not 'like' most data types being imported except
for 'txt' files, so I saved the 'xls' as 'txt' and that didn't work either,
receiving the same "mismatch" error message. (Crudely, I can always 'cut &
paste' my data into a table I guess).

My question is if there is a "Type mismatch" on a truly text
data type, converted 'xls' file, what is Access 'matching' the data type
against since
no table (and therefore no data & structure) was ever presented as the
import destination? How can something be 'mismatched' if there is nothing
(presented) to 'match' it against?

Thx...
Earl

Jul 28 '07 #1
4 1944
i don't have an answer for you, Earl, but i'm interested in the outcome,
too. if you don't get a useful response (or get a thread going) by the end
of the day, suggest you repost your question to
microsoft.publi c.access.extern aldata newsgroup. folks with more expertise
lurk there, including MVP John Nurick; so you may get the help you need.

hth
"Earl Anderson" <is*****@optonl ine.netwrote in message
news:ez******** *****@newsfe12. lga...
I guess I missed the boat on the logic for this one. Immediately upon
hitting "Import" in an
attempt to import an Excel file containing 7 columns of 'txt' formatted
data
into AXP, I got a "Type mismatch" error. A search of previous posts
indicated that Access did not 'like' most data types being imported except
for 'txt' files, so I saved the 'xls' as 'txt' and that didn't work
either,
receiving the same "mismatch" error message. (Crudely, I can always 'cut
&
paste' my data into a table I guess).

My question is if there is a "Type mismatch" on a truly text
data type, converted 'xls' file, what is Access 'matching' the data type
against since
no table (and therefore no data & structure) was ever presented as the
import destination? How can something be 'mismatched' if there is nothing
(presented) to 'match' it against?

Thx...
Earl

Jul 28 '07 #2
Hey,

I'm no expert, but I think that if the data is getting "misunderst ood"
by Access, you probably have a literal string (probably composed of
alpha-numeric characters) and the string has a leading number (a
number is the first character). I've had a similar issue and I
noticed that if Access is expecting a number, there will be issues
with anything that is not numeric data.

I noticed this when I'd be loading a spreadsheet into Access to
compare. The spreadsheet had a list of clients, but some were new
participants (via the Net) and some were existing clients. The new
clients would have a temporary client ID that would be converted.
However, their temporary ID would begin with a "t" to indicate the
type of client and what we can expect. Here's an example (albeit a
short one) of a list:

102340
134567
t3375

Above are the client IDs. Now since Access is expecting a number, it
will have some funky stuff happen when it gets to the "t3375" and I
believe (I've forgotten, to be honest) that it will chop off the data
and then put it into an "import errors" table within the database.
One way to get around this is to have two separate tables for your
data (one table is numbers only and one table is alpha-numeric) as
Access will interpret one table as having all numbers in that column
and the other table will have a string of alpha-numeric characters.

Well, I know I haven't given too much help, but I think this will
point you in the right direction and you can further research this.
Let me know what turns up.

Cheers!

The Beantown Dude

On Jul 28, 11:59 am, "tina" <nos...@address .comwrote:
i don't have an answer for you, Earl, but i'm interested in the outcome,
too. if you don't get a useful response (or get a thread going) by the end
of the day, suggest you repost your question to
microsoft.publi c.access.extern aldata newsgroup. folks with more expertise
lurk there, including MVP John Nurick; so you may get the help you need.

hth

"Earl Anderson" <isob...@optonl ine.netwrote in message

news:ez******** *****@newsfe12. lga...
I guess I missed the boat on the logic for this one. Immediately upon
hitting "Import" in an
attempt to import an Excel file containing 7 columns of 'txt' formatted
data
into AXP, I got a "Type mismatch" error. A search of previous posts
indicated that Access did not 'like' most data types being imported except
for 'txt' files, so I saved the 'xls' as 'txt' and that didn't work
either,
receiving the same "mismatch" error message. (Crudely, I can always 'cut
&
paste' my data into a table I guess).
My question is if there is a "Type mismatch" on a truly text
data type, converted 'xls' file, what is Access 'matching' the data type
against since
no table (and therefore no data & structure) was ever presented as the
import destination? How can something be 'mismatched' if there is nothing
(presented) to 'match' it against?
Thx...
Earl- Hide quoted text -

- Show quoted text -

Jul 30 '07 #3
One work around would be, insert a row of text in the 1st row of date from
Excel. This will cause Access to import all columns as text.

"boston_dud e" <ia********@gma il.comwrote in message
news:11******** ************@w3 g2000hsg.google groups.com...
Hey,

I'm no expert, but I think that if the data is getting "misunderst ood"
by Access, you probably have a literal string (probably composed of
alpha-numeric characters) and the string has a leading number (a
number is the first character). I've had a similar issue and I
noticed that if Access is expecting a number, there will be issues
with anything that is not numeric data.

I noticed this when I'd be loading a spreadsheet into Access to
compare. The spreadsheet had a list of clients, but some were new
participants (via the Net) and some were existing clients. The new
clients would have a temporary client ID that would be converted.
However, their temporary ID would begin with a "t" to indicate the
type of client and what we can expect. Here's an example (albeit a
short one) of a list:

102340
134567
t3375

Above are the client IDs. Now since Access is expecting a number, it
will have some funky stuff happen when it gets to the "t3375" and I
believe (I've forgotten, to be honest) that it will chop off the data
and then put it into an "import errors" table within the database.
One way to get around this is to have two separate tables for your
data (one table is numbers only and one table is alpha-numeric) as
Access will interpret one table as having all numbers in that column
and the other table will have a string of alpha-numeric characters.

Well, I know I haven't given too much help, but I think this will
point you in the right direction and you can further research this.
Let me know what turns up.

Cheers!

The Beantown Dude

On Jul 28, 11:59 am, "tina" <nos...@address .comwrote:
i don't have an answer for you, Earl, but i'm interested in the outcome,
too. if you don't get a useful response (or get a thread going) by the
end
of the day, suggest you repost your question to
microsoft.publi c.access.extern aldata newsgroup. folks with more
expertise
lurk there, including MVP John Nurick; so you may get the help you need.

hth

"Earl Anderson" <isob...@optonl ine.netwrote in message

news:ez******** *****@newsfe12. lga...
I guess I missed the boat on the logic for this one. Immediately upon
hitting "Import" in an
attempt to import an Excel file containing 7 columns of 'txt'
formatted
data
into AXP, I got a "Type mismatch" error. A search of previous posts
indicated that Access did not 'like' most data types being imported
except
for 'txt' files, so I saved the 'xls' as 'txt' and that didn't work
either,
receiving the same "mismatch" error message. (Crudely, I can always
'cut
&
paste' my data into a table I guess).
My question is if there is a "Type mismatch" on a truly text
data type, converted 'xls' file, what is Access 'matching' the data
type
against since
no table (and therefore no data & structure) was ever presented as the
import destination? How can something be 'mismatched' if there is
nothing
(presented) to 'match' it against?
Thx...
Earl- Hide quoted text -
- Show quoted text -


Jul 30 '07 #4
What?? And miss out on the excessive work that I've
recommended? ;o)

Seriously, that sounds like a much easier solution.

Cheers!

The Boston Dude
On Jul 30, 4:15 pm, "paii, Ron" <n...@no.comwro te:
One work around would be, insert a row of text in the 1st row of date from
Excel. This will cause Access to import all columns as text.

"boston_dud e" <ian.gan...@gma il.comwrote in message

news:11******** ************@w3 g2000hsg.google groups.com...
Hey,
I'm no expert, but I think that if the data is getting "misunderst ood"
by Access, you probably have a literal string (probably composed of
alpha-numeric characters) and the string has a leading number (a
number is the first character). I've had a similar issue and I
noticed that if Access is expecting a number, there will be issues
with anything that is not numeric data.
I noticed this when I'd be loading a spreadsheet into Access to
compare. The spreadsheet had a list of clients, but some were new
participants (via the Net) and some were existing clients. The new
clients would have a temporary client ID that would be converted.
However, their temporary ID would begin with a "t" to indicate the
type of client and what we can expect. Here's an example (albeit a
short one) of a list:
102340
134567
t3375
Above are the client IDs. Now since Access is expecting a number, it
will have some funky stuff happen when it gets to the "t3375" and I
believe (I've forgotten, to be honest) that it will chop off the data
and then put it into an "import errors" table within the database.
One way to get around this is to have two separate tables for your
data (one table is numbers only and one table is alpha-numeric) as
Access will interpret one table as having all numbers in that column
and the other table will have a string of alpha-numeric characters.
Well, I know I haven't given too much help, but I think this will
point you in the right direction and you can further research this.
Let me know what turns up.
Cheers!
The Beantown Dude
On Jul 28, 11:59 am, "tina" <nos...@address .comwrote:
i don't have an answer for you, Earl, but i'm interested in the outcome,
too. if you don't get a useful response (or get a thread going) by the
end
of the day, suggest you repost your question to
microsoft.publi c.access.extern aldata newsgroup. folks with more
expertise
lurk there, including MVP John Nurick; so you may get the help you need.
hth
"Earl Anderson" <isob...@optonl ine.netwrote in message
>news:ez******* ******@newsfe12 .lga...
I guess I missed the boat on the logic for this one. Immediately upon
hitting "Import" in an
attempt to import an Excel file containing 7 columns of 'txt'
formatted
data
into AXP, I got a "Type mismatch" error. A search of previous posts
indicated that Access did not 'like' most data types being imported
except
for 'txt' files, so I saved the 'xls' as 'txt' and that didn't work
either,
receiving the same "mismatch" error message. (Crudely, I can always
'cut
&
paste' my data into a table I guess).
My question is if there is a "Type mismatch" on a truly text
data type, converted 'xls' file, what is Access 'matching' the data
type
against since
no table (and therefore no data & structure) was ever presented as the
import destination? How can something be 'mismatched' if there is
nothing
(presented) to 'match' it against?
Thx...
Earl- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

Jul 30 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
6899
by: Stian Søiland | last post by:
all examples performed with: Python 2.3+ (#2, Aug 10 2003, 11:09:33) on linux2 (2, 3, 0, 'final', 1) This is a recursive import:
97
4350
by: Kjetil Torgrim Homme | last post by:
often when re-factoring code, I need to change the indent level of some chunk of code. due to the lack of an end marker, my Emacs has to use heuristics when re-indenting, and this will occasionally lead to mistakes. of course this is really _my_ fault, not Emacs', but it's annoying all the same. a colleague uses #fi, #yrt etc. to mark the...
2
3064
by: David Berry | last post by:
Hi All. I'm looking for any help or sample code that can show me how to make a file import wizard in ASP.NET (VB preferred) like the one that MS Access uses. I'm working on a web site where the user has the ability to upload a file (.txt or .csv). The data in the file may be comma delaminated, tab delaminated, fixed width etc (we don't know). ...
1
8164
by: mark | last post by:
In Access 2000 and 2002, I have created an import specification to import the fixed-width recordset below into an existing table. I am having strange problems with the import of the date and time fields. 177 102003 16:43:12 102003 18:43:12 6OAG0ADP Y 0000 0000 0000 0000 61930 4HGA800 165 102003 17:43:12 102003 18:44:12 6OAG0ADP Y 0000 0000...
10
2548
by: shumaker | last post by:
I don't need a detailed description of a solution(although I wouldn't mind), but I am hoping someone could tell me in general the best path to go about accomplishing a task, since I don't know all the capabilities of what I have available. I can learn the details myself I think. I am trying to set this up to be as simple to use as possible...
3
5406
by: Mudcat | last post by:
I have a directory structure that contains different modules that run depending on what the user selects. They are identical in name and structure, but what varies is the content of the functions. They will only need to be run once per execution. Example (directory level): Sys1: A B C
2
7028
by: google | last post by:
Is there anyway to programatically confirm that specific field names exist in the first row of a given Excel spreadsheet from code within Access? I have code set up to import data from our spreadsheets from HQ into our Access database for further use, using the first row as column headings to determine the destination field in the Access...
0
1444
by: Anders J. Munch | last post by:
Now 2.5 is out, and we have a syntax for explicit relative imports (PEP 328, http://www.python.org/dev/peps/pep-0328/, in case anyone wasn't paying attention). The long-term plan is that the classical import syntax becomes absolute import only, so that all imports are explicitly one or the other. You can only use relative import from...
4
1399
by: Brian Blais | last post by:
Hello, I am trying to organize some of my code, and am having a little trouble with the import logic. I find I often have something like: MyPackage/ Part1/ # wants to use functions in Common/ __init__.py # does "from MyClass1 import MyClass1", etc,... MyClass1.py MyClass1a.py # depends on MyClass1
0
7578
marktang
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...
0
7780
Oralloy
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. ...
0
7862
tracyyun
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...
0
6119
agi2029
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...
0
5136
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...
0
3539
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...
0
3530
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1994
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
1
1111
muto222
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.