Microsoft SQL data transfer to EEPROM

[PICTRAIL]

Here i come again. I appreciate you all for the ever ready help.

I have a table in Ms SQL with 8 character per row. I want to transfer this data to PIC16F877A EEPROM through Visual Basic 2008.
Any resources on this would highly be appreciated. Thanks.
Btw, i'm using UART to USB communication channel.

Regards!

[Brian Griffin]

Here i come again. I appreciate you all for the ever ready help.

I have a table in Ms SQL with 8 character per row. I want to transfer this data to PIC16F877A EEPROM through Visual Basic 2008.
Any resources on this would highly be appreciated. Thanks.
Btw, i'm using UART to USB communication channel.

Regards!

I used excel to compile the data, and stowed it in an SPI EEPROM. Not sure whether this would work in your configuration or not though.

[PICTRAIL]

Kindly shed more light on the excel - Spi communication. Both receive and transmit. I'm sure it will be useful.
Thanks.

[Brian Griffin]

Kindly shed more light on the excel - Spi communication. Both receive and transmit. I'm sure it will be useful.
Thanks.

I used a manual method - use excel to tabulate the data, then convert into a text file with commas.

Then I programmed the EEPROM chip (SPI interface) using my Pickit2. A modification of the compiler is done, which is very tedious and not really recommended.

[PICTRAIL]

Oh i see... Nice concept. Pls any sample code for SPI read and write?...