How can I transfer data from external EEPROM to PC

Forum 2005-2010 (read only) Hardware Interfacing
1

I have an arduino set up to read and store data in external EEPROM. External EEPROM is connected to analog pin 4(SDA) and analog pin 5(SCL). When I read data from the ext. EEPROM, it is shown on arduino's serial monitor.

How can I get this data transferred to a PC program , such as EXCEL?

2

Use a number of steps:

  1. Transfer data from serial to PC. If you want fault tolerance, implement something like XMODEM or better and send your EEPROM contents as a file.
    The PC side would run some kind of terminal emulation software.

  2. Use the received file to convert it to CSV on the PC side. Much more power, but you could save a step by writing CSV from the Aurduino - and if you are really cheap, you just copy and paste the output into a text file.

  3. Import CSV file into Excel.

All of these steps can be combined into one big program, but as we have learned from the lesson of Ed Gruberman...

Keep it simple.

3

Re: How can I transfer data from external EEPROM to PC
Reply #1 - Today at 01:49:43 Use a number of steps:

  1. Transfer data from serial to PC.

That's exactly what I don't know how to do. :-[

4

Try to follow this article:

5

Or you can use GoBetwino:

6

How can I get this data transferred to a PC program , such as EXCEL?

First, make sure your sketch prints out the data as one line per record, with commas between the fields (i.e. a CSV format).

Turn off the Arduino serial monitor.

Start hyperterminal. Connect to the Arduino (using the serial parameters in your sketch).

Select transfer -> capture text. Choose a filename with a .csv extension.

Reset the arduino so it runs the sketch from the beginning and dumps all the data.

Select transfer -> capture text -> stop

open your .csv file. Excel should be the default app for that file type.

-j

7

I'm not sure what this means, what are the serial parameters?

Connect to the Arduino (using the serial parameters in your sketch).

Thank you

8

read the data, send it out the serial port in Comma,Separated,Value, save on pc as a text file (copy and paste from the serial monitor is the easiest way i can think of, for all computer OS's)

Open in excel, do the little wizard dance (delimited, comma, next, finish) and you should have a spreadsheet (I do this from my palm pilot.. um VII, all the time at work with a basic freeware spreadsheet app that still runs on a 9 year old plam pilot)

or write a pc based program / script / whatever to do it all for you packaged in a tidy xls file

;D

9

what are the serial parameters?

Baud rate is what you set in the Serial.begin() call. 8 data bits, 1 stop bit, no parity, no flow control.

-j