473,395 Members | 2,796 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Access 2000 can't import DB3 or 4 or 5 files

Has anyone ever had a problem with Access 2000 not being able to import a DB
(3,4 or 5) delimited file? I get an "unexpected database error" . Other
users I speak to don't have any problem at all. Any ideas?
Need some help
John
Nov 12 '05 #1
2 2605
There are a few articles that may help. These two had error messages similar
to what you mentioned.

http://support.microsoft.com/default...roduct=acc2000
http://support.microsoft.com/default...roduct=acc2000

--
Wayne Morgan
Microsoft Access MVP
"John Maloney" <jc***@optonline.net> wrote in message
news:t_*********************@news4.srv.hcvlny.cv.n et...
Has anyone ever had a problem with Access 2000 not being able to import a DB (3,4 or 5) delimited file? I get an "unexpected database error" . Other
users I speak to don't have any problem at all. Any ideas?
Need some help
John

Nov 12 '05 #2

I have experienced a similar problem (can't attach DB3 db) on one particular
machine and the fix has been to get Access 2000 update (SP or patch?) from
Microsoft web site. It fixed the problem OK.

"Wayne Morgan" <co***************************@hotmail.com> a écrit dans le
message de news: U5*****************@newssvr33.news.prodigy.com...
There are a few articles that may help. These two had error messages similar to what you mentioned.

http://support.microsoft.com/default...&Product=acc20
00 http://support.microsoft.com/default...&Product=acc20
00
--
Wayne Morgan
Microsoft Access MVP
"John Maloney" <jc***@optonline.net> wrote in message
news:t_*********************@news4.srv.hcvlny.cv.n et...
Has anyone ever had a problem with Access 2000 not being able to import a
DB
(3,4 or 5) delimited file? I get an "unexpected database error" .

Other users I speak to don't have any problem at all. Any ideas?
Need some help
John


Nov 12 '05 #3

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

Similar topics

3
by: Doug Baroter | last post by:
Hi, One of my clients has the following situation. They use Access DB for data update etc. some business functions while they also want to view the Access data quickly and more efficiently in...
2
by: Ivan | last post by:
Hi, SQL Server 2000 SP3 Windos 2000 Server SP4 I have a DTS package that imports data from a dBase IV databse with files located in two folders (dBF1 and dBF2). I use a transform data task...
1
by: Steve Claflin | last post by:
I have a database with a moderate number of records in several tables (the biggest table at the moment is about 800 records). In development it got moved between 2K and XP repeatedly. Several...
1
by: D Mat | last post by:
Hi, I'm trying to get MS Access 2000 to automatically import a series of (~200) flat text, tab delimited, data files into a single Access table, with consistent fields and rows. The files have...
4
by: Zen | last post by:
I'm using Access 2000, and I'd like to know if there is a way to use a scanner (flatbed, doc-feed, etc) to scan forms with OMR or OCR software, and have the data be automatically (or if not...
1
by: JoeBobHankey | last post by:
Background: - I'm running MSDE 2000 (not client tools, stored procedure capability, etc). This may change, but not in the first part of development. - My Access file is an Access 2002 project...
1
by: Child of His | last post by:
I have been through every trick I know, or has been suggested. I have a one to two million line fixed field database in text format. I want to bring it into Access 97. When I use the external...
1
by: Wandering | last post by:
I know you guys are heavy duty coders, while I do ad-hoc analysis, and rarely write code. And, I may be in the wrong groups because this is about an install issue, and I don't think it's a code...
1
by: tezza98 | last post by:
I need some help. Im using a dtsrun command to import 9 tables into an Access database, most of the tables have about 1000 rows, but one has 20000+ rows and grows everyday. Im Using Access 2003...
1
by: thadson | last post by:
Hi, I'm trying to import specific cells from MS Excel 2000 spreadsheets to MS Access 2000 tables then move the spreadsheets to a different directory. I'm very new to this and I'm having trouble...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
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...
0
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,...
0
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,...

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.