Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Inserting Excel Into Access Database


  • Please log in to reply
2 replies to this topic

#1 icasey

icasey

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:01:05 PM

Posted 26 June 2007 - 09:30 PM

I am using office 2003 and need to combine 20 plus spreadsheets with identical headings into an access database. Each spreadsheet contains about 1-2000 records and there could be about 500 spread sheets. Maybe some type of lookup table - any ideas welcomed.

BC AdBot (Login to Remove)

 


#2 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,574 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:11:05 PM

Posted 26 June 2007 - 09:46 PM

File menu > Get External Data and then click Import.
I don't recall whether the merger happens during import or whether you will merge several new Access tables into one later.

Make sure you have simple column properties, really clear dates, text, numbers. You can tweak things in Access but only if the initial conversion didn't mess up.

#3 icasey

icasey
  • Topic Starter

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:01:05 PM

Posted 28 June 2007 - 07:15 PM

Thanks for that I will give it a try

Regards,

Ian




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users