about importing data to access

R

Rimpy

i have microsoft Access 2003 and trying to import the data from the text
file, but when i select the file to be imported in the import window and
click import, the import text wizard window doesnt appear and i am not able
to import data from the text file,
 
W

Wojciech Wendrychowicz

i have microsoft Access 2003 and trying to import the data from the text
file, but when i select the file to be imported in the import window and
click import, the import text wizard window doesnt appear and i am not
able
to import data from the text file,
Click to expand...

Try from VBA-Code:
Docmd.TransferText [F1]
 
J

John Nurick

Hi Rimpy,

If the import/export wizards don't work at all, re-register ACCWIZ.DLL

If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.
 
Top