about importing data to access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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]
 
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.
 
Back
Top