• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

What is the ‘best’ way to import data into Excel from Access?

S

Stuck1

New Member
What is the ‘best’ way to import data into Excel from Access? I’m using Excel 2003 and I’m importing data that has been exported from an Access database (as an xls file), the data has the following fields:


1. Event (String)

2. Start Date

3. End Date


An ID is always present as is a START DATE, however the END DATE can sometimes be NULL as not every event has ended (yet). The problem is that Excel thinks the END DATE is a string field as the first record in the exported Access file is NULL. Therefore, the imported data in the END DATE column shows all values as NULL.


I have this problem every now and again, but this is an automated process, so I don’t want to have to employ any kind of work around, such as formatting and reformatting data or sorting and resorting. My method for importing data to Excel seems to be the problem. What am I missing??


Thanks for any help.
 
This is a now cross posted here:


http://www.mrexcel.com/forum/excel-questions/698718-what-%91best%92-way-import-data-into-excel-access.html#post3453005


Sorry for being a little impatient, but I hoping to sort this as soon as possible, as I can't carry on with the rest of the db until this bit is sorted.


Having read around the subject for the past hour or so I'm starting to think that exporting as xml and importing (into Excel) as xml is the way to go, I've never used this format, it seems straight forward, but I don't want to overlook anything.
 
Good day Stuck1


I think you have answerd your own question :) but this link may help you


http://support.microsoft.com/kb/305795
 
Thanks, XML seems to sort it, but I don't like that 'generated' column that is automatically created.
 
Hi, Stuck1!

Consider uploading a sample file of the Access database and include a sample file of the Excel workbook desired or the layout of the main worksheet. It'd be very useful for those who read this and might be able to help you. Thank you.

Give a look at the green sticky posts at this forums main page for uploading guidelines.

Regards!
 
You must log in or register to reply here.
Back
Top