Export data to phone

[scott]

I want to export data to a phone. Based on trial and error, I've learned
that the phone software utility (Nokia) expects the data to be in a specific
format. I am able to reproduce pretty faithfully using a report, but when I
export the data (Publish with Word), it adds lines at page breaks so the
utility doesn't like the format and fails to import. The format it expects
is something like:
First name: Bill
Last name: Johnson
General mobile: 234 343 4444

First name: Joe
Last name: Anderson
General mobile: 234 343 4555

etc.

Has someone been able to get data from an Access database to a Nokia phone?
What are the tips and tricks?

Thanks.

 

[John Spencer]

Instead of exporting a report to word, try exporting a query to a text file.
If you need carraige returns and line feeds incorporate them in the query.
See example

SELECT "First Name: " & [FirstNameField] as FN
, Chr(13) & Chr(10) & "Last Name: " & [LastNameField] as LN
, Chr(13) & Chr(10) & "General Mobile: " & [MobilePhone] as GM
FROM [Your Table]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[scott]

This comes very close. I modified your suggestion slightly to get the line
feeds in the right place.

SELECT "First name: " & [First Name] & Chr(13) & Chr(10) AS FN
, "Last name: " & [Last Name] & Chr(13) & Chr(10) AS LN
, "General mobile: " & [Business Mobile] & Chr(13) & Chr(10) AS GM
FROM [PCV Data];

It produces this report:

First name: Andy
Last name: Arnold
General mobile: 017 790 555

First name: Bill
Last name: Jones
General mobile: 017 790 556

First name: Lance
Last name: Simpson
General mobile: 017 790 557

When I export I select space as the delimiter and None for the text
qualifier. The problem is the space at the beginning of each of the lines
after the first line. If I select a comma as the delimiter, I get a comma
where I don't want it. If I leave the " as the text qualifier I get a lot of
" in the file that are not wanted.

Any suggestions?

Instead of exporting a report to word, try exporting a query to a text file.
If you need carraige returns and line feeds incorporate them in the query.
See example

SELECT "First Name: " & [FirstNameField] as FN
, Chr(13) & Chr(10) & "Last Name: " & [LastNameField] as LN
, Chr(13) & Chr(10) & "General Mobile: " & [MobilePhone] as GM
FROM [Your Table]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I want to export data to a phone. Based on trial and error, I've learned
that the phone software utility (Nokia) expects the data to be in a specific
format. I am able to reproduce pretty faithfully using a report, but when I
export the data (Publish with Word), it adds lines at page breaks so the
utility doesn't like the format and fails to import. The format it expects
is something like:
First name: Bill
Last name: Johnson
General mobile: 234 343 4444

First name: Joe
Last name: Anderson
General mobile: 234 343 4555

etc.

Has someone been able to get data from an Access database to a Nokia phone?
What are the tips and tricks?

Thanks.

 

[John Spencer]

I would try
Text Qualifier: None
Delimiter: Other
And leave the box for Other BLANK

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

This comes very close. I modified your suggestion slightly to get the line
feeds in the right place.

SELECT "First name: " & [First Name] & Chr(13) & Chr(10) AS FN
, "Last name: " & [Last Name] & Chr(13) & Chr(10) AS LN
, "General mobile: " & [Business Mobile] & Chr(13) & Chr(10) AS GM
FROM [PCV Data];

It produces this report:

First name: Andy
Last name: Arnold
General mobile: 017 790 555

First name: Bill
Last name: Jones
General mobile: 017 790 556

First name: Lance
Last name: Simpson
General mobile: 017 790 557

When I export I select space as the delimiter and None for the text
qualifier. The problem is the space at the beginning of each of the lines
after the first line. If I select a comma as the delimiter, I get a comma
where I don't want it. If I leave the " as the text qualifier I get a lot of
" in the file that are not wanted.

Any suggestions?

Instead of exporting a report to word, try exporting a query to a text file.
If you need carraige returns and line feeds incorporate them in the query.
See example

SELECT "First Name: " & [FirstNameField] as FN
, Chr(13) & Chr(10) & "Last Name: " & [LastNameField] as LN
, Chr(13) & Chr(10) & "General Mobile: " & [MobilePhone] as GM
FROM [Your Table]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I want to export data to a phone. Based on trial and error, I've learned
that the phone software utility (Nokia) expects the data to be in a specific
format. I am able to reproduce pretty faithfully using a report, but when I
export the data (Publish with Word), it adds lines at page breaks so the
utility doesn't like the format and fails to import. The format it expects
is something like:
First name: Bill
Last name: Johnson
General mobile: 234 343 4444

First name: Joe
Last name: Anderson
General mobile: 234 343 4555

etc.

Has someone been able to get data from an Access database to a Nokia phone?
What are the tips and tricks?

Thanks.

 

[scott]

Tried that. It says the Field Delimiter cannot be blank. Any other ideas?

I would try
Text Qualifier: None
Delimiter: Other
And leave the box for Other BLANK

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

This comes very close. I modified your suggestion slightly to get the line
feeds in the right place.

SELECT "First name: " & [First Name] & Chr(13) & Chr(10) AS FN
, "Last name: " & [Last Name] & Chr(13) & Chr(10) AS LN
, "General mobile: " & [Business Mobile] & Chr(13) & Chr(10) AS GM
FROM [PCV Data];

It produces this report:

First name: Andy
Last name: Arnold
General mobile: 017 790 555

First name: Bill
Last name: Jones
General mobile: 017 790 556

First name: Lance
Last name: Simpson
General mobile: 017 790 557

When I export I select space as the delimiter and None for the text
qualifier. The problem is the space at the beginning of each of the lines
after the first line. If I select a comma as the delimiter, I get a comma
where I don't want it. If I leave the " as the text qualifier I get a lot of
" in the file that are not wanted.

Any suggestions?

Instead of exporting a report to word, try exporting a query to a text file.
If you need carraige returns and line feeds incorporate them in the query.
See example

SELECT "First Name: " & [FirstNameField] as FN
, Chr(13) & Chr(10) & "Last Name: " & [LastNameField] as LN
, Chr(13) & Chr(10) & "General Mobile: " & [MobilePhone] as GM
FROM [Your Table]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

scott wrote:
I want to export data to a phone. Based on trial and error, I've learned
that the phone software utility (Nokia) expects the data to be in a specific
format. I am able to reproduce pretty faithfully using a report, but when I
export the data (Publish with Word), it adds lines at page breaks so the
utility doesn't like the format and fails to import. The format it expects
is something like:
First name: Bill
Last name: Johnson
General mobile: 234 343 4444

First name: Joe
Last name: Anderson
General mobile: 234 343 4555

etc.

Has someone been able to get data from an Access database to a Nokia phone?
What are the tips and tricks?

Thanks.

 

[John Spencer]

Then try this idea - export one field that is a concatenation of the fields.

SELECT "First Name: " & [FirstNameField] & Chr(13) & Chr(10) & "Last Name: "
& [LastNameField] & Chr(13) & Chr(10) & "General Mobile: " & [MobilePhone] &
Chr(13) & Chr(10) As ONEBIGHonkingFIELD
FROM [Your Table]

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Instead of exporting a report to word, try exporting a query to a text
file. If you need carraige returns and line feeds incorporate them in
the query. See example

SELECT "First Name: " & [FirstNameField] as FN
, Chr(13) & Chr(10) & "Last Name: " & [LastNameField] as LN
, Chr(13) & Chr(10) & "General Mobile: " & [MobilePhone] as GM
FROM [Your Table]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I want to export data to a phone. Based on trial and error, I've
learned that the phone software utility (Nokia) expects the data to be
in a specific format. I am able to reproduce pretty faithfully using a
report, but when I export the data (Publish with Word), it adds lines
at page breaks so the utility doesn't like the format and fails to
import. The format it expects is something like:
First name: Bill
Last name: Johnson
General mobile: 234 343 4444

First name: Joe
Last name: Anderson
General mobile: 234 343 4555

etc.

Has someone been able to get data from an Access database to a Nokia
phone? What are the tips and tricks?

Thanks.

 

[scott]

Bingo. Thank you very much.

Then try this idea - export one field that is a concatenation of the fields.

SELECT "First Name: " & [FirstNameField] & Chr(13) & Chr(10) & "Last Name: "
& [LastNameField] & Chr(13) & Chr(10) & "General Mobile: " & [MobilePhone] &
Chr(13) & Chr(10) As ONEBIGHonkingFIELD
FROM [Your Table]

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Instead of exporting a report to word, try exporting a query to a text
file. If you need carraige returns and line feeds incorporate them in
the query. See example

SELECT "First Name: " & [FirstNameField] as FN
, Chr(13) & Chr(10) & "Last Name: " & [LastNameField] as LN
, Chr(13) & Chr(10) & "General Mobile: " & [MobilePhone] as GM
FROM [Your Table]


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

I want to export data to a phone. Based on trial and error, I've
learned that the phone software utility (Nokia) expects the data to be
in a specific format. I am able to reproduce pretty faithfully using a
report, but when I export the data (Publish with Word), it adds lines
at page breaks so the utility doesn't like the format and fails to
import. The format it expects is something like:
First name: Bill
Last name: Johnson
General mobile: 234 343 4444

First name: Joe
Last name: Anderson
General mobile: 234 343 4555

etc.

Has someone been able to get data from an Access database to a Nokia
phone? What are the tips and tricks?

Thanks.