Stock Trading and Other Things

How can I import stock quotes into MS Access?

I've tried importing the quotes to Excel and importing from there to Access, but it doesn't transfer cleanly. Is there a way to get the data into Access directly?

Public Comments

1. Getting the data into MS-Access depends on the format of that data. If you have gotten it into MS-Excel successfully, then there should be no problem importing it into a Table within MS-Access.

But the best way to go from MS-Excel to MS-Access is to do a SAVE AS... to the file type of CSV (Comma delimited). This will make a much cleaner import into MS-Access, especially if you tell Access that every field is a Text data type.

.