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?
- How can I import live stock exchange stock prices into MS Excel?
- How do I find out if an online stock is worth buying into?
- Are online stock brokers required to report funds coming into the account over $10k just like banks?
- Are there any adapters to turn a stock stereo CD-Changer in into a standard Line-In?
- What line of study should I go into to become a stock broker?
- How can I start buying stock online if I don’t have 500 dollars to put into the account?
- How do I get into buying/investing in the STOCK market online?
- Is now the time to buy into the stock market and trade? ?
- direct access trading platform for stock market?
- I’m interested in learning about and getting into online stock trading. Any resources or favorites?
- how can I get into online stock trading?
- 2010 AAPL stock quotes, 2010 AAPL stock prices, 2010 AAPL stock charts, 2010 AAPL stock split ?
- How to get into stock market and buy and trade / sell stock?
- Hi, I signed up with your realtime stock quotes and I want to make use of your “tagging” scheme to download da
- can someone throughly explain how to splice a line out converter into my stock radio?
MaryettaC
March 13, 2010 at 9:08 am
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.
.