View Full Version : [2003] Adding data from spreadsheet (excel)


PsYiOn
09-17-2008, 02:38 AM
I have a database which my application used to pass jobs out to the people in my team. We recieve new jobs in the forum a spreadsheet which can be formated just like the database table. I need to get these from Excel into my access table.

Any ideas? Is there a feature in access that will let me import them? Or maybe somthing in Excel that lets you dump to an access file?

Kind Regards

PsYiOn

ajetrumpet
09-17-2008, 02:40 AM
all you need to do is use the import wizard. it lets you import data into a new table or an existing table.