I've copied & pasted tables from websites into AAC before and it worked just fine. I just selected the text data, and then clicked the table button and AACs table function automatically recognized each cell and each row and did i perfectly. So I know it has the capability. When I do the same thing from Excel however, it doesn't work. It lump all the columns together in each row. I tried saving my document in several formats thinking it was some kind of invisible formatting issue but no luck. So what do I have to do?

 

You could try:

Save the Excel file as an *.html file
View the file in your Internet browser
Copy/paste from that file

 

You could try:

Save the Excel file as an *.html file
View the file in your Internet browser
Copy/paste from that file

Yeah the result is the same. looks like this:
(copied from HTML file)

QTYNewark PART #DESCRIPTION UNIT COST TOTAL COST 393K5434 PCB mount 12V relay $ 2.28 $ 6.84 226R4228 RESISTOR, METAL GLAZE, 20 MOHM, 500 MW, ± 5% $ 0.12 $ 0.24 196M9178
12V wall wart p/s for fault tester $ 13.53 $ 13.53 1070R0064TERM BLK, PCB, SCREW, 5.0MM, 2WAY $ 0.73 $ 7.30 113T9276Enclosure for the Arduino Duemilanove or Mega w/ Ethernet Shield $ 9.46 $ 9.46 113T9277

ARDUINO UNO Board w/ Workshop Starter Kit (just buy the 25$ arduino, not the kit)
$ 71.38 $ 71.38 213T9280
PROTOTYPE BOARD FOR ARDUINO UNO $ 10.42 $ 20.84 389K1072TIP120 DARLINGTON TRANSISTOR, NPN, 60V, TO-220 $ 0.43 $ 1.29 101M7886CONVERTER, DC/DC, 1.5W, +1000V
$ 183.00 $ 183.00 131K7040OPTOCOUPLER, DARLINGTON, 3750VRMS $ 7.02 $ 7.02 Total $ 320.90

I've tried html, csv, etc.

should look like this:

 

As far as I know, columns are separated by the | symbol.
You have to have the same number of columns in each line.

 

As far as I know, columns are separated by the | symbol.
You have to have the same number of columns in each line.

That's not working either.

|QTY | Newark PART # | DESCRIPTION | UNIT COST | TOTAL COST
|3 | 93K5434 | PCB mount 12V relay | $ 2.28 | $ 6.84
|2 | 26R4228 | RESISTOR, METAL GLAZE, 20 MOHM, 500 MW, ± 5% | $ 0.12 | $ 0.24
|1 | 96M9178 | 12V wall wart p/s | $ 13.53 | $ 13.53
|10 | 70R0064 | TERM BLK, PCB, SCREW, 5.0MM, 2WAY | $ 0.73 | $ 7.30
|1 | 13T9276 | Enclosure for the Arduino Duemilanove or Mega | $ 9.46 | $ 9.46
|1 | 13T9277 | ARDUINO UNO Board w/ Workshop Starter Kit (just buy the 25$ arduino, not the kit) | $ 71.38 | $ 71.38
|2 | 13T9280 | PROTOTYPE BOARD FOR ARDUINO UNO | $ 10.42 | $ 20.84
|3 | 89K1072 | TIP120 DARLINGTON TRANSISTOR, NPN, 60V, TO-220| $ 0.43 | $ 1.29
|1 | 01M7886 | CONVERTER, DC/DC, 1.5W, +1000V | $ 183.00 | $ 183.00
|1 | 31K7040 | OPTOCOUPLER, DARLINGTON, 3750VRMS | $ 7.02 | $ 7.02
| | | | Total | $ 320.90

|QTY | Newark PART # | DESCRIPTION                                   | UNIT COST | TOTAL COST 
|3   | 93K5434       | PCB mount 12V relay                           | $ 2.28    | $ 6.84 
|2   | 26R4228       | RESISTOR, METAL GLAZE, 20 MOHM, 500 MW, ± 5%  | $ 0.12    | $ 0.24 
|1   | 96M9178       | 12V wall wart p/s                             | $ 13.53   | $ 13.53 
|10  | 70R0064       | TERM BLK, PCB, SCREW, 5.0MM, 2WAY             | $ 0.73    | $ 7.30 
|1   | 13T9276       | Enclosure for the Arduino Duemilanove or Mega | $ 9.46    | $ 9.46 
|1   | 13T9277       | ARDUINO UNO Board w/ Workshop Starter Kit (just buy the 25$ arduino, not the kit) | $ 71.38 | $ 71.38 
|2   | 13T9280       | PROTOTYPE BOARD FOR ARDUINO UNO               | $ 10.42   | $ 20.84 
|3   | 89K1072       | TIP120 DARLINGTON TRANSISTOR, NPN, 60V, TO-220| $ 0.43    | $ 1.29 
|1   | 01M7886       | CONVERTER, DC/DC, 1.5W, +1000V                | $ 183.00  | $ 183.00 
|1   | 31K7040       | OPTOCOUPLER, DARLINGTON, 3750VRMS             | $ 7.02    | $ 7.02   
|    |               |                                               | Total     | $ 320.90

EDIT: AHA! apparently it is working, just not in the post preview. how strange!
Still, That took me a while in noepad putting all those extra characters in. it would be nice if it were as simple as copy & paste.

 

Hey guys that's fantastic. Thanks a bundle I've been wanting to display tables for ages.

| 1234 |Col test1|tabletest1|
|123456|line2|tabletest1

 

I guess you could insert columns of | in the spreadsheet. Still fairly tedious.

This little formula should do it:

ITEM| PRICE|
Resistor| 0.01|
Flux Capacitor| 12700.39|
PIC10F200| 0.34|

I guess you have to convert the original to text if you want the currency sign to work.

 

The wise men of the Forum,good job guys.