Question about Microsoft Office Access 2003 (077-02871) for PC
I need to import data from access into excel where one column go into one worksheet and other into next worksheet
Nowadays, with the development of the technology, you are able to crack excel password so as to access your files again safely and very easily with excel password reset programs. And Excel password recovery is a popular tool that can reset Excel password from Excel 97 to Excel 2007. Meanwhile, it can open your file again without any damage or data loss at all.
Posted on Nov 30, 2011
Can't be done.
Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.
There are two ways to get around it:
1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.
2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.
Hope that helps you out.
Posted on Jun 10, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Acess will only export the data into an Excel spreadsheet with each element of the record going into a sperate column.
You can record macros to get the data to go where you want it to go on the spreadsheet.
Posted on Jun 10, 2008
Tips for a great answer:
Oct 17, 2013 | Panduit Easy-Mark Labeling Software...
on Jul 27, 2010 | Microsoft Excel for PC
Nov 15, 2010 | Microsoft Windows XP Professional
Dec 14, 2009 | Microsoft Windows XP Professional
Mar 24, 2009 | Microsoft Excel for PC
Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)
Sep 30, 2008 | Microsoft Excel for PC
Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...
Nov 22, 2007 | Microsoft Excel for PC
Oct 22, 2017 | Microsoft Office Access 2003 (077-02871)...
Jun 24, 2017 | Microsoft Office Access 2003 (077-02871)...
307 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: