Question Problem facing in Importing .csv file to access (1 Viewer)

Srini

New member
Local time
Today, 15:37
Joined
Nov 21, 2011
Messages
2
Hi,

I am trying to import .csv file to access - getting the below error:

The microsoft jet database engine could not find the object ". Make sure the object exists and that you spell its name and the path name correctly.

Can anyone help me with the solution.

Thanks
Srini
 

DavidAtWork

Registered User.
Local time
Today, 10:07
Joined
Oct 25, 2011
Messages
699
Srini, you'll have to be a bit more specific. Post your code and highlight the line where it's failing, if it's erroring without giving you the option to debug, then you need to step through your code right from the first event call to see which line is the problem
David
 

vbaInet

AWF VIP
Local time
Today, 10:07
Joined
Jan 22, 2010
Messages
26,374
The error could mean that the name you gave for the destination table could not be found. So check that you typed in the correct name. But like DavidAtWork mentioned, we need to see the code line.
 

Srini

New member
Local time
Today, 15:37
Joined
Nov 21, 2011
Messages
2
Hi,

There is no code involved in this scenario.

- I exported data file from external database in .csv format
- tired to import in access by choosing Get external data option
- selected the source file
- opted for delimited and text qualifier as "
- at last it is showing the error file not imported succesfully due to object " not found.

Even I specified the file name correctly - showing the same error.

Thanks,
Srini
 

vbaInet

AWF VIP
Local time
Today, 10:07
Joined
Jan 22, 2010
Messages
26,374
So when the Import dialog initially pops-up, what option did you select?
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 10:07
Joined
Sep 12, 2006
Messages
15,614
make sure your csv is not open in notepad or excel - you cannot import a "locked" file.

are you definitely selecting the correct field separator, normally comma, but can be other things.
 

Users who are viewing this thread

Top Bottom