Import from Access or Excel 2007?

[Faszikam]

Is this possible, either directly or indirectly? Does anyone have any
guidelines?

[Richard Gravina]

I've been doing quite a lot of this just recently. The method I use is a bit
fiddly, but works well and is reasonably quick.

If the data is in an Access table, export it to Excel.
In Excel, put in extra columns between each column of data.
Fill the blank columns with the appropriate backslash marker for the column
next to it (\lx, \de etc.).
Select the data, copy it and paste it into Word. It will appear as a table.
Convert the table to text, using a space to separate the fields.
In Search and Replace, replace \ with ^p\ This will put each field on a
separate line.
Save the document as a text file.
Import the file into FLEx as a SFM format file.

If anyone knows a simpler way, I would be interested to hear about it too!
I've tried setting up a report in Access to do this, but that was actually
harder.

Richard Gravina

[Robert Hedinger]

With SheetSwiper you can convert Excel tables (with the backslash markers as
the column headers) to standard format files. Very nice and easy.
If you want each marker in each entry, make sure blank cells have some
content, otherwise there will be no marker.

I could try to find out where I got it from, or somebody else can just post
the source on the list here.

Robert

--------------------------------------------------
From: "Richard Gravina" <Richard-S...@sil.org>
Sent: Wednesday, July 01, 2009 2:53 PM
To: <flex...@googlegroups.com>
Subject: [FLEx] Re: Import from Access or Excel 2007?

[Andy Black]

On 7/1/2009 7:21 AM, Robert Hedinger wrote:
> With SheetSwiper you can convert Excel tables (with the backslash markers as
> the column headers) to standard format files. Very nice and easy.
> If you want each marker in each entry, make sure blank cells have some
> content, otherwise there will be no marker.
>
> I could try to find out where I got it from, or somebody else can just post
> the source on the list here.
>

It looks like it can be obtained from http://code.google.com/p/sheetswiper/.

--Andy

[John Hatton]

I've updated SheetSwiper to version 0.3, which now lives at here Palaso.  The largest change is more consistent Unicode handling.

 

John Hatton

SIL PNG, Palaso, & SIL International Software Development

Google Talk chat: hattonjohn