Excel Spreadsheet into Access 2000

C

Charlene

I have been given an Excel Spreadsheet to import into
Access 2000. This spreadsheet goes on and on.
month/year, forecast spend, actual spend by month and
year. What is the best way to set this up in Access? Can
I break the information up so my form is not real long.
and so where I don't have to retype any of the information
from the excel spreadsheet.
The headings are as follows: Status / ALIAS / Plan-Pt
2003 / Forecast Pt 2003 / Plan Total Expenses 2003 / Jan
2003 forecast / Jan 2003 Actual etc...it also includes the
same info for 2002 - 2007
 
I

Innominato

From my expirience it depend how your excell data are organized, if you have
hiden cells or merged or anything similliar, from expirience best way is to
use ole.

Stanko.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort headings? 1
Make Forecasts - How extensive is it? 2
Access 2007 to mimic spreadsheet 1
Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1
Query from an Excel spreadsheet 0
Access won't open Excel spreadsheet 0
Does complicated sumproduct formula crashes excel? 7
Unable to update field in linked table using a form. 0

Top