Cannot Import .CSV Files - Option Not Available in Drop Down Box

J

JEO

I do not have the option to import .csv files into Microsoft Access. I was
having this same problem w/ .xls, but found the answer on how to fix that on
the forum (the fix worked). I now need to know how to enable the .csv files
(as soon as possible).

Thank you.
 
J

JEO

Jerry,

Microsoft 2003. I am not sure where to find service pack. I looked at help
and about and there was no help when the option just isn't there.
 
J

JEO

Gina,

Would the following be the service pack: Microsoft 2003 11.5614.6568? If so,
now what do I need to do in order to fix this?

Thank you.
 
J

JEO

I have a disk my uncle gave me with the programs. I was having issues with my
laptop late last year and had to take my laptop to be fixed. When the issues
I was having were fixed this problem appeared. I was guessing it would be
another easy fix like the .xls files. I fixed that.

Please help.
 
G

Gina Whipp

JEO,

I was going to suggest reloading Access using Custom or Advanced (I forget
what the choices are) to insure you have installed the Advanced Filters.
However, using disks your Uncle gave you... well that is up to you becuase
you should have your own license.

And now that I think about it... in the drop down box, do you have the
option to import .txt files?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
J

JEO

The program says my name when you look to find the service pack. I don't know
much about computers though so someone else installed the software. Do I need
to get different software?

I do not have the option to import .txt files. The only options I have are
Excel (which I just fixed in order to have that option), Access, Sharepoint,
and XML.
 
J

JEO

I do not know how, but I do know how to follow directions...so if you tell me
how I will do it.
 
G

Gina Whipp

JEO,

I would suggest you get the person who loaded Access to reload with the
Advanced part checked, so they can confirm the features added (if you can).
(I don't remember ALL the steps and ALL the coices to give complete
directions.) If you want to do it yourself, the below MIGHT help...

1. Insert CD
2. Select Add/Remove Features...
3. Select Advanced and check all the boxes
4. All done now see what is in the Drop Down in Access.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
J

JEO

So there is no easy fix like the one fix fix it so I could import .xls?

The person who loaded it orinally can't help. The person who loaded it next
was the Geek Squad at Best Buy...
 
G

Gina Whipp

JEO,

If there is an easy fix I have not been able to find it. And it occurs to
me that perhaps all the filters where not loaded, at least, at this point it
is the only thing coming to mind. Note, Best Buy will want the original CD,
they will not load a copy.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
J

JEO

How do I load the filters? Best Buy did load the CD 2/09. That is all I have
and I gave it to them.
 
G

Gina Whipp

It is under Advanced Options... Like I said haven't loaded a CD in a while
and don't remember exactly where that is why I suggested someone with
experience do it.

A thought here... are you sure you don't actually have Access Runtime, as
opposed to the full edition?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
J

JEO

How do I know if I have Access Runtime?

Gina Whipp said:
It is under Advanced Options... Like I said haven't loaded a CD in a while
and don't remember exactly where that is why I suggested someone with
experience do it.

A thought here... are you sure you don't actually have Access Runtime, as
opposed to the full edition?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
CSV Import Error 2
Cannot import CSV file into ACCESS 1
Link a text box based on drop down box with four options MS Word 365 0
Import Multiple CSV Files from Same Folder into Open Workbook 5
Import fields from .csv with variable column structure 4
Import, Rename .csv files with date created as field 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top