Import Text Wizard Doesn't Work in Access 2003

musicloverlch

What's up with the text import wizard in Access 2003? We have a large
text file that needs to be imported. Tried it on Access 2003 and it
just sits there with an hourglass. Tried it on Access 97 and it opened
right up!

Any ideas?

Thanks in advance,
Laura

Nov 13 '05 #1

Subscribe Reply

5648

David Lloyd

Laura:

It's hard to know the exact cause without more information, however the
following two KB articles deal with the type of problem you are seeing. The
second article does not specifically refer to importing text files, so it
may not be relevant.

http://support.microsoft.com/default...b;en-us;835415
http://support.microsoft.com/kb/303805/EN-US/

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"musicloverlch" <lh****@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
What's up with the text import wizard in Access 2003? We have a large
text file that needs to be imported. Tried it on Access 2003 and it
just sits there with an hourglass. Tried it on Access 97 and it opened
right up!

Any ideas?

Thanks in advance,
Laura

Nov 13 '05 #2

by: David Aylott | last post by:

Greetings When I use the import text wizard with a fixed width text file, I add a break at the correct column but it doesn't line up with the text. It seems that the display is shown in a...

Microsoft Access / VBA

Text Import Problem (Quoted Identifier and Comma-delimited)

by: DCM Fan | last post by:

Access 2K, SP3 on Windows 2K, SP4 All, I have an import spec set up with quoted Identifiers and comma-separated values. The text file is produced by a 3rd-party program of which I have no...

Microsoft Access / VBA

Text Import Wizard Problem in XP

by: Jenny | last post by:

Since I got a new PC with XP and the latest version of Access on it, I have been having problems with the Text Import Wizard. In the section where you specify the field options, when I click on...

Microsoft Access / VBA

Type conversion problems with Access Import Wizard

by: deko | last post by:

I've been trying to use the Access Import Wizard to expedite importing data into my mdb. The nice thing about the wizard is that I can import from different file formats - txt, xls, even Outlook -...

Microsoft Access / VBA

File Import Wizard

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...

Visual Basic .NET

Import Wizard

by: pendell | last post by:

I am working with a client running 2003 Access. Some time ago I built them an import spec for use with the Import Wizard. Several months later, I have been called back and asked to solve a...

Microsoft Access / VBA

table from .ADP to tab delimited text file

by: Ted Theo | last post by:

hello cdma enthusiasts. long time no speak. i have an .adp which is connected to a sql 2k back end from which i need to export a table to a tab delimited text file. the export text wizard...

Microsoft Access / VBA

import data from csv file

by: a | last post by:

Dear friends I want import data from CSV file to mdb file How can I do that in vb.net?

Visual Basic .NET

Error in data import? It's worked using this template several times prior!

by: geolemon | last post by:

Import text wizard says: I'm banging my head on this one, here's why: I've been importing files using this process and data format, with success! I created a temporary table in Access to...

Microsoft Access / VBA

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

What is ONU?

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,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

AI Job Threat for Devs

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,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

transfer the data from one system to another through ip address

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 ...

C# / C Sharp

Import Text Wizard Doesn't Work in Access 2003

Similar topics