Errors while importing data

[imran688]

I just created a new database and tried to import data from excel sheet. But some wild errors appear as i try to import the data. i have taken the screen shots of the errors. Basically these errors show when even i try to export data, create a button on forms etc. Please help me to resolve it.

Please tale a look on screenshots. (From right to left)

[imran688]

A little correction.
First message is 3rd from left.
Second message is 2nd from left.
Third message is 1st from left
Fourth message is 4th from left.

[tanvi]

Hopefully you have a backup.

If the Visual Basic for Applications project is corrupted, forms, reports, and modules also get corrupted by this corruption. You should use "Compact & Repair" utility to repair your database. If it does not work then you should try third party Access Database Recovery Software to repair corrupt access database.



"Database or object is read-only": The file that you are importing or that you are trying to export does not have a recognized file name extension. For more information, please visit this link: http://support.microsoft.com/kb/245407


"the database cannot be opened because the vba project contained in it cannot be read": Please visit this link for more information:
http://support.microsoft.com/kb/2533794


"microsoft access cannot find the wizard. this wizard has not been installed": Please visit this link for more information:
http://support.microsoft.com/kb/2581301

[rpeare]

I haven't encountered those errors before but it looks like it's choking on trying to load a reference (vb scripting reference). Have you tried reinstalling MS access?

[tanvi]

I did not re-install MS access. If you got these error messages, I will never recommend you to re-install access database because in this case you can lost your data. If the data is not precious then You can try following steps to re-install MS access:

Click Start, and then click Control Panel.
Double-click Add or Remove Programs, click Microsoft Office 2003, and then click Change.
In the Microsoft Office 2003 Setup dialog box, click Reinstall or Repair, and then click Next.
Click either Reinstall Office or Detect and Repair errors in my Office installation, and then click Install.
For more information, please visit this link: http://support.microsoft.com/kb/821593

[imran688]

In fact the best solution to this problem is to delete the VBA folder (I don't remember the folder location) and then repair MS Office. That worked for me.