Data Transfer btw EEPROM and USART

[PICTRAIL]

Hi,
I am designing a system which can receive data from SQL database through USART using PIC16F877A. Here is where my problem lies: I intend to store a table of 4 Columns and 10 Rows on EEPROM from my PC SQL Database through Visual Basic.

Each column consist of Name, ID, Unit Code and Confirmation.

Finally i wish to automatically update my SOL database for registered confirmation through the EEPROM.

Can anyone advise on how to go about it or if possible provide a sample source code.

Thanking you for your anticipating support.

[ABSF]

Are you aware that the eeprom of 877A is only 256 bytes in size? A 4x10 database would get about 6 bytes per field. Is that enough for your usage. And besides, the eeprom reads and writes are slower than the flash and ram so it would take longer time for your data to transfer from PC to PIC.

If the size is too small, adding a 24C32 (4096 bytes) I2C external eeprom might solve your problem.

Allen

[PICTRAIL]

Thanks alot for the idea... I will research about the FLASH. If you have any analysis on this i will really appreciate.

[Brian Griffin]

Hi,
I am designing a system which can receive data from SQL database through USART using PIC16F877A. Here is where my problem lies: I intend to store a table of 4 Columns and 10 Rows on EEPROM from my PC SQL Database through Visual Basic.

Each column consist of Name, ID, Unit Code and Confirmation.

Finally i wish to automatically update my SOL database for registered confirmation through the EEPROM.

Can anyone advise on how to go about it or if possible provide a sample source code.

Thanking you for your anticipating support.

To be safe, try using SD card. I believe it is because the table might be too large for an EEPROM.

[PICTRAIL]

OK... Thanks so much i really appreciate your advise... I will definitely review that.