#1   Report Post  
Mindy
 
Posts: n/a
Default import file

Hi, I have all of my personal addresses in an AnyTime file. I have exported
it as a .csv file. I then open Excel and when I try to import it, it says
cannot access "address.csv". this is my personal computer so there shouldn't
be any problems with permission rights. if anyone can help me, I would
really appreciate it. Thanks, Mindy
  #2   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"Mindy" wrote in message
...
Hi, I have all of my personal addresses in an AnyTime file. I have

exported
it as a .csv file. I then open Excel and when I try to import it, it says
cannot access "address.csv". this is my personal computer so there

shouldn't
be any problems with permission rights. if anyone can help me, I would
really appreciate it. Thanks, Mindy


What happens if you double click on the file? Does it open? Also make sure
you really point a the right csv file, there may be other files around.

/Fredrik


  #4   Report Post  
Mindy
 
Posts: n/a
Default

If I double click on the file, it opens Excel but still says cannot access
file

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
Hi, I have all of my personal addresses in an AnyTime file. I have

exported
it as a .csv file. I then open Excel and when I try to import it, it says
cannot access "address.csv". this is my personal computer so there

shouldn't
be any problems with permission rights. if anyone can help me, I would
really appreciate it. Thanks, Mindy


What happens if you double click on the file? Does it open? Also make sure
you really point a the right csv file, there may be other files around.

/Fredrik



  #6   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"Mindy" wrote in message
...
If I double click on the file, it opens Excel but still says cannot access
file


If you follow Don's suggestion to first open Excel from the start menu and
then use File|Open, do you still get the same problem? I guess the program
could be locked by some other program or previous instance of Excel. Have
you tried to restart your PC?

/Fredrik


  #7   Report Post  
Mindy
 
Posts: n/a
Default

I will restart my computer now.

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
If I double click on the file, it opens Excel but still says cannot access
file


If you follow Don's suggestion to first open Excel from the start menu and
then use File|Open, do you still get the same problem? I guess the program
could be locked by some other program or previous instance of Excel. Have
you tried to restart your PC?

/Fredrik



  #8   Report Post  
Mindy
 
Posts: n/a
Default

restarting didn't help.

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
If I double click on the file, it opens Excel but still says cannot access
file


If you follow Don's suggestion to first open Excel from the start menu and
then use File|Open, do you still get the same problem? I guess the program
could be locked by some other program or previous instance of Excel. Have
you tried to restart your PC?

/Fredrik



  #9   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"Mindy" wrote in message
...
restarting didn't help.

What about File|Open? Do make absolutely sure you ioen the right file. If
the csv file doesn't hold any sensitive information, send it to me and I
will see if I have better luck. My exceptionally long email address is


/Fredrik


  #10   Report Post  
Dave Peterson
 
Posts: n/a
Default

I don't have a guess, but can you open the .csv file in NotePad via File|Open?

If no, it sounds like something is locking that file. (Rebooting usually fixes
that, sigh.)

Can you copy that file to a new .csv file and open that one?

Can you create it again using AnyTime?

Heck, maybe it's Anytime that's locking the file. Have you tried accessing the
file when Anytime isn't running (maybe when Anytime hasn't even been
started???).

Mindy wrote:

Hi, I have all of my personal addresses in an AnyTime file. I have exported
it as a .csv file. I then open Excel and when I try to import it, it says
cannot access "address.csv". this is my personal computer so there shouldn't
be any problems with permission rights. if anyone can help me, I would
really appreciate it. Thanks, Mindy


--

Dave Peterson


  #11   Report Post  
Mindy
 
Posts: n/a
Default

I have tried all your suggestions but I cannot open that file. I even
renamed the file but that didn't help either. Does anyone know the software
Anytime Deluxe? That's the program I need the information out of.

Mindy

"Dave Peterson" wrote:

I don't have a guess, but can you open the .csv file in NotePad via File|Open?

If no, it sounds like something is locking that file. (Rebooting usually fixes
that, sigh.)

Can you copy that file to a new .csv file and open that one?

Can you create it again using AnyTime?

Heck, maybe it's Anytime that's locking the file. Have you tried accessing the
file when Anytime isn't running (maybe when Anytime hasn't even been
started???).

Mindy wrote:

Hi, I have all of my personal addresses in an AnyTime file. I have exported
it as a .csv file. I then open Excel and when I try to import it, it says
cannot access "address.csv". this is my personal computer so there shouldn't
be any problems with permission rights. if anyone can help me, I would
really appreciate it. Thanks, Mindy


--

Dave Peterson

  #12   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"Mindy" wrote in message
...
I have tried all your suggestions but I cannot open that file. I even
renamed the file but that didn't help either. Does anyone know the

software
Anytime Deluxe? That's the program I need the information out of.

Mindy


Not me, I don't know this program. As I said, if the file isn't personal or
holds sensitive information, you can send it to and I will see if I can open
it.

/Fredrik


  #13   Report Post  
Mindy
 
Posts: n/a
Default

If you wouldn't mind taking a look at it, I would really appreciate it!
Don't worry, it doesn't have any sensitive information. I'm getting married
next month so I'm trying to export the addresses to help with the envelopes.
What email address should I send the file to?

Mindy

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
I have tried all your suggestions but I cannot open that file. I even
renamed the file but that didn't help either. Does anyone know the

software
Anytime Deluxe? That's the program I need the information out of.

Mindy


Not me, I don't know this program. As I said, if the file isn't personal or
holds sensitive information, you can send it to and I will see if I can open
it.

/Fredrik



  #14   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"Mindy" wrote in message
...
If you wouldn't mind taking a look at it, I would really appreciate it!
Don't worry, it doesn't have any sensitive information. I'm getting

married
next month so I'm trying to export the addresses to help with the

envelopes.
What email address should I send the file to?

Mindy


It seems as if you missed my previous post. Anyway, the email address is

It's getting really late in my part of the world so it will take until
"tomorrow" before I do anything with the file.

/Fredrik


  #15   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you can email it, can't you create a copy and use that?

Mindy wrote:

If you wouldn't mind taking a look at it, I would really appreciate it!
Don't worry, it doesn't have any sensitive information. I'm getting married
next month so I'm trying to export the addresses to help with the envelopes.
What email address should I send the file to?

Mindy

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
I have tried all your suggestions but I cannot open that file. I even
renamed the file but that didn't help either. Does anyone know the

software
Anytime Deluxe? That's the program I need the information out of.

Mindy


Not me, I don't know this program. As I said, if the file isn't personal or
holds sensitive information, you can send it to and I will see if I can open
it.

/Fredrik




--

Dave Peterson


  #16   Report Post  
Mindy
 
Posts: n/a
Default

I wish I could but I can't even open the file to try to copy it.

"Dave Peterson" wrote:

If you can email it, can't you create a copy and use that?

Mindy wrote:

If you wouldn't mind taking a look at it, I would really appreciate it!
Don't worry, it doesn't have any sensitive information. I'm getting married
next month so I'm trying to export the addresses to help with the envelopes.
What email address should I send the file to?

Mindy

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
I have tried all your suggestions but I cannot open that file. I even
renamed the file but that didn't help either. Does anyone know the
software
Anytime Deluxe? That's the program I need the information out of.

Mindy


Not me, I don't know this program. As I said, if the file isn't personal or
holds sensitive information, you can send it to and I will see if I can open
it.

/Fredrik




--

Dave Peterson

  #17   Report Post  
Dave Peterson
 
Posts: n/a
Default

Mail it to yourself.

Save the attachment as a new name???



Mindy wrote:

I wish I could but I can't even open the file to try to copy it.

"Dave Peterson" wrote:

If you can email it, can't you create a copy and use that?

Mindy wrote:

If you wouldn't mind taking a look at it, I would really appreciate it!
Don't worry, it doesn't have any sensitive information. I'm getting married
next month so I'm trying to export the addresses to help with the envelopes.
What email address should I send the file to?

Mindy

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
I have tried all your suggestions but I cannot open that file. I even
renamed the file but that didn't help either. Does anyone know the
software
Anytime Deluxe? That's the program I need the information out of.

Mindy


Not me, I don't know this program. As I said, if the file isn't personal or
holds sensitive information, you can send it to and I will see if I can open
it.

/Fredrik




--

Dave Peterson


--

Dave Peterson
  #18   Report Post  
Mindy
 
Posts: n/a
Default

When I do that, it will open up but it's all gobberish.

"Dave Peterson" wrote:

Mail it to yourself.

Save the attachment as a new name???



Mindy wrote:

I wish I could but I can't even open the file to try to copy it.

"Dave Peterson" wrote:

If you can email it, can't you create a copy and use that?

Mindy wrote:

If you wouldn't mind taking a look at it, I would really appreciate it!
Don't worry, it doesn't have any sensitive information. I'm getting married
next month so I'm trying to export the addresses to help with the envelopes.
What email address should I send the file to?

Mindy

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
I have tried all your suggestions but I cannot open that file. I even
renamed the file but that didn't help either. Does anyone know the
software
Anytime Deluxe? That's the program I need the information out of.

Mindy


Not me, I don't know this program. As I said, if the file isn't personal or
holds sensitive information, you can send it to and I will see if I can open
it.

/Fredrik




--

Dave Peterson


--

Dave Peterson

  #19   Report Post  
Dave Peterson
 
Posts: n/a
Default

gibberish if you open that emailed copy in Notepad/wordpad, too?

Either way, I don't have another guess.



Mindy wrote:

When I do that, it will open up but it's all gobberish.

"Dave Peterson" wrote:

Mail it to yourself.

Save the attachment as a new name???



Mindy wrote:

I wish I could but I can't even open the file to try to copy it.

"Dave Peterson" wrote:

If you can email it, can't you create a copy and use that?

Mindy wrote:

If you wouldn't mind taking a look at it, I would really appreciate it!
Don't worry, it doesn't have any sensitive information. I'm getting married
next month so I'm trying to export the addresses to help with the envelopes.
What email address should I send the file to?

Mindy

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
I have tried all your suggestions but I cannot open that file. I even
renamed the file but that didn't help either. Does anyone know the
software
Anytime Deluxe? That's the program I need the information out of.

Mindy


Not me, I don't know this program. As I said, if the file isn't personal or
holds sensitive information, you can send it to and I will see if I can open
it.

/Fredrik




--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #20   Report Post  
Mindy
 
Posts: n/a
Default

Hi guys,

I finally got it! Turns out it needed to be a .txt file, not a .csv file.

Mindy

"Dave Peterson" wrote:

gibberish if you open that emailed copy in Notepad/wordpad, too?

Either way, I don't have another guess.



Mindy wrote:

When I do that, it will open up but it's all gobberish.

"Dave Peterson" wrote:

Mail it to yourself.

Save the attachment as a new name???



Mindy wrote:

I wish I could but I can't even open the file to try to copy it.

"Dave Peterson" wrote:

If you can email it, can't you create a copy and use that?

Mindy wrote:

If you wouldn't mind taking a look at it, I would really appreciate it!
Don't worry, it doesn't have any sensitive information. I'm getting married
next month so I'm trying to export the addresses to help with the envelopes.
What email address should I send the file to?

Mindy

"Fredrik Wahlgren" wrote:


"Mindy" wrote in message
...
I have tried all your suggestions but I cannot open that file. I even
renamed the file but that didn't help either. Does anyone know the
software
Anytime Deluxe? That's the program I need the information out of.

Mindy


Not me, I don't know this program. As I said, if the file isn't personal or
holds sensitive information, you can send it to and I will see if I can open
it.

/Fredrik




--

Dave Peterson


--

Dave Peterson


--

Dave Peterson



  #21   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"Mindy" wrote in message
...
Hi guys,

I finally got it! Turns out it needed to be a .txt file, not a .csv file.


Hi

Nice catch! I think there's a problem with csv files if they start with a
particular character, Excel apparently becomes confused and claims the file
is invalid or similar. I hope the wedding goes well.

/Fredrik


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Excel Data from another workbook or file tamato43 Excel Discussion (Misc queries) 1 February 28th 05 05:26 PM
how do I enable "import text file" excel 2002? jw_schmid Excel Discussion (Misc queries) 2 February 9th 05 10:39 PM
How can I import a text file into excel with each field as a sepe. [email protected] Excel Discussion (Misc queries) 8 January 18th 05 02:31 AM
import problem on huge xls file f_huba@toplita. Excel Worksheet Functions 2 November 5th 04 12:09 AM
Import file names into cells craigwojo Excel Worksheet Functions 2 November 2nd 04 11:19 PM


All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"