Re: Linked table shows no data
- From: "John Nurick" <j.mapson.nurick@xxxxxxxxxxxxxx>
- Date: Tue, 20 Jun 2006 16:18:46 +0100
Probably because there's something different about the file. For instance,
text files from non-Windows computers sometimes use different characters for
the line breaks, and this can confuse Access's import routine. So can text
files that contain null bytes (i.e. bytes whose value is 00, nothing to do
with a database's NULL values).
If you open the file with Notepad, does it show up properly, or are there
incorrect line breaks and/or other oddities?
"Ess" <ess@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9EF43E3D-BFAB-4444-9859-E7AB2978FCB2@xxxxxxxxxxxxxxxx
I am trying to link a .CSV file to Access. When using the Link Text
Wizard,
I see the data that's in the table and complete the steps. Once the steps
are completed and the table is linked, I open the table and there is no
data.
The field names and only one row of blank data.
I linked two other .CSV tables and the data shows. Any idea why the data
is
not showing for this linked table?
--
If you never attempt anything, you will never make any mistakes...thus
never
enjoying the fruits of accomplishment.
.
- Prev by Date: Re: Exporting mass MS Word and Excell OLE's to seperate MS Word and Excell files from Access 97 DB
- Next by Date: Re: Create local copy of Linked Table
- Previous by thread: Re: importing from excel with formulas
- Next by thread: Re: Linked table shows no data
- Index(es):
Relevant Pages
|
