(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Importing .mdb file to Sesame
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Importing .mdb file to Sesame (Read 1118 times)
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Importing .mdb file to Sesame
Oct 4th, 2011 at 9:06pm
Print Post Print Post  
I received an MS Access .mdb file. Problem is that I do not have Access program to export it to other format to be imported to Sesame. Is there a way I could import that file using Sesame?  Well, I do not even know the structure of the data. The company had to send me the file in Access format as Excel file causes problem with 0 values as per him. Any suggestions?
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Importing .mdb file to Sesame
Reply #1 - Oct 4th, 2011 at 9:10pm
Print Post Print Post  
I can dump it for you, if you want.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Importing .mdb file to Sesame
Reply #2 - Oct 4th, 2011 at 9:13pm
Print Post Print Post  
You can also attach to the Access database from Excel and use Excel to export it.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Rick_R
Full Member
***
Offline



Posts: 243
Joined: Jan 29th, 2010
Re: Importing .mdb file to Sesame
Reply #3 - Oct 4th, 2011 at 9:22pm
Print Post Print Post  
Can they send it in CSV format dumped from Access?  (I have Access at home but not here. I think it can dump in CSV but I'm not certain.)

Also, check this out:  accessing an Access database with OpenOffice Base using ODBC: http://www.openoffice.org/FAQs/ms-access/ms-access.html
  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Importing .mdb file to Sesame
Reply #4 - Oct 4th, 2011 at 10:38pm
Print Post Print Post  
As Erika pointed out, I could open .mdb file in Excel and I saved it as Excel file. Later on saving as .csv file would lose all the leading zeros and that would make file unusable. However, when I saved as Tab delimited text file, leading zeros were preserved. Problem solved!  Thanks everyone.
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge