Thanks very much for the tips. It sounds from what you describe, like the main issue in achieving a successful import (using copy table wizard) is ensuring that the data type definitions in each of the to-be columns of the new base table, will accommodate the data that will be coming into them from MSA. So I'll try it again, and this time will carefully review the data types Base has selected, before approving them. Although, most of my columns are just of type "text", so I would think they would accommodate most anything. As say suggest though, I'll check to be sure they are varchar( 255 ).
If it doesn't work for any reason the next time round, I'm thinking to try the csv method. Barbara explained very clearly how to export from MSA into a csv format. I would like to know how (simple, step-by-step) to do the import from csv format into linux Base. Will you be posting that HowTo in your addition to the MSA-Base wiki? One other thing: don't know if you saw where I described the problem I'm having with the 'read-only' table that I get when connecting Base to a table in MSA. If you could suggest some solution to this, I'd be grateful Thanks again, Swarup P.S. As you suggest, I'll have a look at Calc as well. On Thu, 2007-08-30 at 07:20 -0400, Andrew Jensen wrote: > Hi Dinbandhu, > > I've been at the msa -> base conversion page for a couple of hours ( still > on my machine, so don't go look as I have only been using StarOffice / now > need to try OpenOffice ). > > I just went back and read over this thread again and a couple of comments to > you however, > > 1) There is no such thing as a date only field in MS Access. You may have a > column defined as a date in Access, and you may never have added a time > value but internally they are only date/time fields. > > 2) Be sure that if you have any Auto Increment fields in Access that you set > the field types of BIGINT in Base, by hand. AutoIncrement in Access is > always a LONG INTEGER. > > 3) Currency fields. In Base be sure to add decimal places - by hand. Base > copy table dialog selects numeric with 0 decimal places. Any decimal values > in the source are lost in the transfer if you don't make the change. > > 4) TEXT fields in Access. Always set these to varchar( 255 ) > > One final comment for now ( and if Marc reads this I believe he will laugh ) > the best way to get a handle on what the data is going to look like coming > over from Access is to use Calc. > > Assuming your Base file that connects to your mdb file is registered then > all you do is create a new Calc file. Open the datasource window ( F4 ), > select your Base file and open it. Open the table item and then drag one of > the tables onto the sheet. > > In the case of your date fields you will see that every row where you > entered only a date in Acesss a date and a time of 00:00 ( no seconds ). > > Currency fields in Access, when there is a negative value. Bringing the data > to Calc had no problems - even formatted the darn things as currency, on > it's own. > > You asked if the import "By my question I was just trying to get a sense of > how good Base's > import wizard is. i.e. does it give most people trouble? Or is rather my > data giving it trouble? " > > >From my experience, and I have helped perhaps a few dozen people convert the > data in some way. If you are under MS Windows no problems, a hicup maybe, > but not a real problem. Under Linux - not so good. > > > > > On 8/30/07, Dinbandhu <[EMAIL PROTECTED]> wrote: > > > > On Wed, 2007-08-29 at 22:56 -0500, Barbara Duprey wrote: > > > > > > Dinbandhu wrote: > > > > <snip> > > > > Tell me, is this copy table wizard usually trouble-free? Or are others > > > > also having trouble with it. I just want to get a sense of whether > > this > > > > tool is quite finicky, or is it just an isolated sort of problem I am > > > > having and for most folks it goes without a hitch. > > > > > > > I've only recently gotten into this area myself (had a largish table to > > > get in from a .dbf file, then updates to pick up from Writer tables and > > > Calc spreadsheets). I had problems with various aspects -- the .dbf one > > > worked fine (and that's probably more like your Access stuff than the > > > other sources I used), and so did Calc, but I had some ill-behaved data > > > in a Writer table that violated uniqueness when used as a key, and Base > > > added leading and trailing blanks to text fields that made them violate > > > lengths when I tried to restrict the fields to their proper sizes. (I've > > > since found out how to strip them off again easily.) The Calc > > > spreadsheet worked fine, too. So I'd say the success probably depends > > > more on the source type than anything else, and Access should be pretty > > > good. To get more of a feel for how frequent the problems are, you'd > > > probably have to look at the archives of this list and the > > > [EMAIL PROTECTED] list, or check the Issue Tracker for what it's > > > got. Maybe somebody else here can help more, or on the dev list (which > > > seems somewhat more active, and has been extremely helpful for me.) > > > > I see. Perhaps that would also be a good mailing list to join. > > > > By my question I was just trying to get a sense of how good Base's > > import wizard is. i.e. does it give most people trouble? Or is rather my > > data giving it trouble? I can hardly think my data would give anyone > > trouble, it's so simple and straightforward. > > > > I'm hopeful that Drew's HowTo on the wiki will help me get find what the > > problem is and get through this. > > > > > > Also, is the other method--via the cvs file--more dependable? That is, > > > > would you recommend that I go that route instead? If so, is there a > > > > simple command in MS Access for exporting a database as a cvs file? > > > > > > > I haven't tried the .csv route at all, but since that's the most basic > > > and straightforward format of all, and serves as the most nearly common > > > language for data transfers, I'd expect it to be the least troublesome. > > > In Access, if you open a table and go to File > Export, you can set the > > > Save As filetype to Text Files, which includes .csv. Set the file name > > > to have the right extension, and Export All; that will bring up an > > > export wizard that leads you through the rest of the process. "csv" > > > stands for "comma separated variables" but you have some other options > > > for separators within that type. > > > > That is very helpful information-- thanks a lot. Now I'm sure I'll be > > able to do the export from MS Access using this method. I would just > > need some similar guidance for the import side into Base. I know you > > haven't done this before. Perhaps either Frank or Drew could give some > > simple step-by-step approach as you have done above for the export. > > > > > > P.S. Don't know whether you had a chance to take a look at the > > > > functionality issue re: when you have simply "connected" with a MDB, > > > > which I had asked Frank about in my last note to him. I have pasted it > > > > just below. Any comments? > > > > > > > > > > > >>> 1. I would like to know that if I just simply "connect" to the MDB > > > >>> > > > > file > > > > > > > >>> and don't import it, then what sort of functionality is there? > > > >>> > > > >> Read/Write data. See MSA's queries as so-called views (i.e. they > > > >> > > > > behave > > > > > > > >> like tables, but you cannot edit their constituting statement). Don't > > > >> see forms/reports/macros. > > > >> > > > > > > > > I see. That is still very good. I was just unable to find the commands > > > > of how to write data there. That is, the tool bar commands for save, > > > > edit data, cut, paste, and data input, are all grayed out. Then there > > > > above those are the File, Edit (all lines grayed out except "copy"), > > > > view, tools, window, and help options but none of them seem to have > > any > > > > option to edit the edit the data, add a row, add a column. And I can't > > > > even put my cursor in any of the cells of the table. In fact, there is > > > > no cursor. In short, in my computer the table and the data in it looks > > > > like a picture window. You can see it, but you can't do anything with > > > > it. > > > > > > > > > > > Not sure what's going on here, but it sounds as if the data is being > > > considered read-only. It may be a matter of permissions or locks. Can > > > you update the data in Access? Do you have Access open on the database > > > when you're trying to work with it in Base? > > > > I update the data in Access all the time. No problem there. I'm not sure > > what you mean when you ask: > > > > > Do you have Access open on the database > > > when you're trying to work with it in Base? > > > > How does one have Access (do you mean the program MS Access) open on a > > database? I'm in Ubuntu Linux doing the import into Base, so of course > > there is no program running on the Windows side. These are two different > > partitions of the same computer. Nothing in Windows is running when I > > have booted to the Linux partition. Perhaps you meant something other > > than what I understood? > > > > Regards, > > Swarup > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
