G
Guest
Is there a field size limitation on importing from Excel? If so, are there
work arounds?
work arounds?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell [MVP]
Just the typical length of a memo field... however, depending upon how you
try to import, you might get truncated data. Provide us with more info about
what you're trying to do.
try to import, you might get truncated data. Provide us with more info about
what you're trying to do.
G
Guest
I believe I am in the process of resolving this issue with TransferText. I
am downloading patent data that can have a Description field of 200 +
characters
The CSV file opens in Excel fine, but when I bring over to Access the data
get truncated.
am downloading patent data that can have a Description field of 200 +
characters
The CSV file opens in Excel fine, but when I bring over to Access the data
get truncated.
K
Ken Snell [MVP]
You're on right track. Use TransferText to import the csv file directly.
G
Guest
TransferText only inported the first row/record, also the memo field was
concatenated to 254 characters.
What am I missing? Or should I look for?
Thanks
concatenated to 254 characters.
What am I missing? Or should I look for?
Thanks
K
Ken Snell [MVP]
Post some sample data from the csv file. Are you importing into an existing
table, or to a new table?
table, or to a new table?
G
Guest
Ken,
I am using an existing table. Is there a way to attach the csv or xls file.
Also, I will stick with this thread, sorry. Also, file is Access 2000
format, does that make a difference?
Also, why do I only get the 1st data row when I TransferText with CSV?
Following is a sample from one cell:
I claim:
1. Fluid pressure level indicator apparatus, comprising:
a housing having first and second inlet openings and first and second
pressure passages therein, wherein the first passage is in fluid
communication with the first inlet opening, wherein the second passage is in
fluid communication with the second inlet opening,
a progressive pressure responsive device supported in said housing and in
fluid communication with said first and second pressure passages, wherein
said progressive pressure responsive device is movable to different discrete
positions in response to the relative pressure levels in said passages,
a position sensor device, wherein the positive sensor device is operative to
detect movement of said progressive pressure responsive device to said
different discrete positions,
signal apparatus responsive to said position sensor device, wherein the
signal apparatus is operative to provide unique signals indicative of said
different discrete positions occupied by said progressive pressure responsive
device, and
a breathing apparatus for supplying breathing air to a user from a
pressurized air supply source, said air supply being connected to said second
passage for movement of said progressive pressure responsive device
responsive to pressure of said air supply source.
4. Fluid pressure level indicator apparatus, comprising:
a housing having first and second pressure passages therein,
a progressive pressure responsive device supported in said housing and in
fluid communication with said first and second pressure passages, wherein
said progressive pressure responsive device is movable to different discrete
positions in response to the relative pressure levels in said passages,
wherein the progressive pressure responsive device comprises a progressive
piston assembly supported in said housing for slidable movement between first
and second positions,
wherein said progressive piston assembly comprises plural pistons having
first and second portions exposed respectively to said first and second
pressure passages, said first and second portions being sized to be
responsive to different relative pressure levels at said first and second
passages to cause movement of said respective piston from one discrete
position to another,
a position sensor device, wherein the sensor device is operative to detect
movement of said progressive pressure responsive device to said different
discrete positions,
signal apparatus responsive to said position sensor device, wherein the
signal apparatus is operative to provide unique signals indicative of said
different discrete positions occupied by said progressive pressure responsive
device, and
a breathing apparatus for supplying breathing air to a user from a
pressurized air supply source said air supply being connected to said second
passage for movement of said progressive pressure responsive device
responsive to pressure of said air supply source.
6. Fluid pressure level indicator apparatus, comprising:
a housing having first and second pressure passages therein,
a progressive pressure responsive device supported in said housing and in
fluid communication with said first and second pressure passages, wherein
said progressive pressure responsive device is movable to different discrete
positions in response to the relative pressure levels in said passages,
wherein the progressive pressure responsive device comprises a progressive
piston assembly supported in said housing for slidable movement between first
and second positions,
wherein said progressive piston assembly comprises a piston slidably
supported in said housing for movement between first and second positions,
said piston having a step therein providing a larger first portion exposed to
air pressure in said first passage and a smaller second portion exposed to
air pressure in said second passage, and further including a spring in said
housing biasing said piston,
a position sensor device, wherein the sensor device is operative to detect
movement of said progressive pressure responsive device to said different
discrete positions,
signal apparatus responsive to said position sensor device wherein the
signal apparatus is operative to provide unique signals indicative of said
different positions occupied by said progressive pressure responsive device,
and
a breathing apparatus for supplying breathing air to a user from a
pressurized air supply source, said air supply being connected to said second
passage for movement of said progressive pressure responsive device
responsive to pressure of said air supply source.
10. Fluid pressure level indicator apparatus, comprising:
a housing having a pressure passage therein,
a progressive pressure responsive device supported in said housing and in
fluid communication with said pressure passage, wherein said responsive
device is movable to different discrete positions in response to the relative
pressure level in said passage,
a position sensor device, wherein the sensor device is operative to detect
movement of said pressure responsive device to said different positions,
signal apparatus responsive to said position sensor device, wherein the
signal apparatus is operative to provide unique signals indicative of said
different positions occupied by said progressive pressure responsive device,
and
wherein said progressive pressure responsive device comprises a progressive
piston assembly supported in said housing for slidable movement between upper
and lower positions,
wherein said progressive piston assembly comprises a single piston slidably
supported in said housing for movement between first and second positions,
said single piston having a step therein providing a larger first portion and
a smaller second portion, said second portion exposed to air pressure in said
passage, and further including a spring in said housing biasing said piston
toward the second position, and
wherein said position sensor device comprises plural detector elements for
sensing plural unique positions of said piston between the first and second
positions.
14. Apparatus comprising:
a source of breathable air,
a first stage regulator,
a second stage regulator, wherein the first stage regulator is positioned
fluidly intermediate the source of breathable air and the second stage
regulator, wherein the first stage regulator is in fluid communication with
the source of breathable air and the second stage regulator;
a fluid line providing fluid communication between the first stage regulator
and the source of breathable air,
a progressive pressure responsive device, wherein the pressure responsive
device includes a movable pressure responsive member and plural elements
therein for detecting various unique positions of the movable pressure
responsive member, said movable pressure responsive member being responsive
to air pressure from said source of breathable air to assume said various
unique positions as the air pressure from said source of breathable air
diminishes; wherein the progressive pressure responsive device is in fluid
communication with the fluid line intermediate the first stage regulator and
the source of breathable air, and
signal apparatus energized by said movable pressure responsive member to
provide unique signals at each of said unique positions in order to warn a
user of impending depletion of the air supply.
19. A breathing apparatus, comprising:
a pressurized breathable air supply source,
an air pressure level indicator apparatus including
a housing having first and second inlet openings and first and second
pressure passages therein, wherein the first passage is in fluid
communication with the first inlet opening, wherein the second passage is in
fluid communication with the second inlet opening, the pressurized breathable
air supply source being fluidly connected to a passage,
a progressive pressure responsive device supported in the housing and in
fluid communication with the first and second air pressure passages, wherein
the progressive pressure responsive device is movable to different discrete
positions in response to the relative air pressure levels in the first and
second air pressure passages,
a position sensor device, wherein the sensor device is operative to detect
movement of the progressive pressure responsive device to the different
discrete positions,
signal apparatus responsive to the position sensor device, wherein the
signal apparatus is operative to provide signals indicative of the different
discrete positions of the progressive pressure responsive device, and
wherein the progressive pressure responsive device is movably responsive to
air pressure of the pressurized breathable air supply source.
20. A breathing apparatus, comprising:
a pressurized breathable air supply source,
an air pressure level indicator apparatus including
a housing having an air pressure passage therein, the pressurized breathable
air supply source being fluidly connected to the passage,
a progressive pressure responsive device including a single piston slidably
supported in the housing, wherein the piston is movable between first and
second positions, and wherein the piston has a step therein providing a
larger first portion and a smaller second portion, the second portion exposed
to air pressure in the passage,
a spring in the housing biasing the piston toward the second position,
wherein the piston is movable to different discrete positions in response to
the relative pressure level in the passage,
a position sensor device including plural detector elements operative to
detect different positions of the piston between the first and second
positions,
signal apparatus responsive to the position sensor device, wherein the
signal apparatus is operative to provide signals indicative of the different
positions of the piston, and
wherein the piston is movably responsive to air pressure of the pressurized
breathable air supply source.
I am using an existing table. Is there a way to attach the csv or xls file.
Also, I will stick with this thread, sorry. Also, file is Access 2000
format, does that make a difference?
Also, why do I only get the 1st data row when I TransferText with CSV?
Following is a sample from one cell:
I claim:
1. Fluid pressure level indicator apparatus, comprising:
a housing having first and second inlet openings and first and second
pressure passages therein, wherein the first passage is in fluid
communication with the first inlet opening, wherein the second passage is in
fluid communication with the second inlet opening,
a progressive pressure responsive device supported in said housing and in
fluid communication with said first and second pressure passages, wherein
said progressive pressure responsive device is movable to different discrete
positions in response to the relative pressure levels in said passages,
a position sensor device, wherein the positive sensor device is operative to
detect movement of said progressive pressure responsive device to said
different discrete positions,
signal apparatus responsive to said position sensor device, wherein the
signal apparatus is operative to provide unique signals indicative of said
different discrete positions occupied by said progressive pressure responsive
device, and
a breathing apparatus for supplying breathing air to a user from a
pressurized air supply source, said air supply being connected to said second
passage for movement of said progressive pressure responsive device
responsive to pressure of said air supply source.
4. Fluid pressure level indicator apparatus, comprising:
a housing having first and second pressure passages therein,
a progressive pressure responsive device supported in said housing and in
fluid communication with said first and second pressure passages, wherein
said progressive pressure responsive device is movable to different discrete
positions in response to the relative pressure levels in said passages,
wherein the progressive pressure responsive device comprises a progressive
piston assembly supported in said housing for slidable movement between first
and second positions,
wherein said progressive piston assembly comprises plural pistons having
first and second portions exposed respectively to said first and second
pressure passages, said first and second portions being sized to be
responsive to different relative pressure levels at said first and second
passages to cause movement of said respective piston from one discrete
position to another,
a position sensor device, wherein the sensor device is operative to detect
movement of said progressive pressure responsive device to said different
discrete positions,
signal apparatus responsive to said position sensor device, wherein the
signal apparatus is operative to provide unique signals indicative of said
different discrete positions occupied by said progressive pressure responsive
device, and
a breathing apparatus for supplying breathing air to a user from a
pressurized air supply source said air supply being connected to said second
passage for movement of said progressive pressure responsive device
responsive to pressure of said air supply source.
6. Fluid pressure level indicator apparatus, comprising:
a housing having first and second pressure passages therein,
a progressive pressure responsive device supported in said housing and in
fluid communication with said first and second pressure passages, wherein
said progressive pressure responsive device is movable to different discrete
positions in response to the relative pressure levels in said passages,
wherein the progressive pressure responsive device comprises a progressive
piston assembly supported in said housing for slidable movement between first
and second positions,
wherein said progressive piston assembly comprises a piston slidably
supported in said housing for movement between first and second positions,
said piston having a step therein providing a larger first portion exposed to
air pressure in said first passage and a smaller second portion exposed to
air pressure in said second passage, and further including a spring in said
housing biasing said piston,
a position sensor device, wherein the sensor device is operative to detect
movement of said progressive pressure responsive device to said different
discrete positions,
signal apparatus responsive to said position sensor device wherein the
signal apparatus is operative to provide unique signals indicative of said
different positions occupied by said progressive pressure responsive device,
and
a breathing apparatus for supplying breathing air to a user from a
pressurized air supply source, said air supply being connected to said second
passage for movement of said progressive pressure responsive device
responsive to pressure of said air supply source.
10. Fluid pressure level indicator apparatus, comprising:
a housing having a pressure passage therein,
a progressive pressure responsive device supported in said housing and in
fluid communication with said pressure passage, wherein said responsive
device is movable to different discrete positions in response to the relative
pressure level in said passage,
a position sensor device, wherein the sensor device is operative to detect
movement of said pressure responsive device to said different positions,
signal apparatus responsive to said position sensor device, wherein the
signal apparatus is operative to provide unique signals indicative of said
different positions occupied by said progressive pressure responsive device,
and
wherein said progressive pressure responsive device comprises a progressive
piston assembly supported in said housing for slidable movement between upper
and lower positions,
wherein said progressive piston assembly comprises a single piston slidably
supported in said housing for movement between first and second positions,
said single piston having a step therein providing a larger first portion and
a smaller second portion, said second portion exposed to air pressure in said
passage, and further including a spring in said housing biasing said piston
toward the second position, and
wherein said position sensor device comprises plural detector elements for
sensing plural unique positions of said piston between the first and second
positions.
14. Apparatus comprising:
a source of breathable air,
a first stage regulator,
a second stage regulator, wherein the first stage regulator is positioned
fluidly intermediate the source of breathable air and the second stage
regulator, wherein the first stage regulator is in fluid communication with
the source of breathable air and the second stage regulator;
a fluid line providing fluid communication between the first stage regulator
and the source of breathable air,
a progressive pressure responsive device, wherein the pressure responsive
device includes a movable pressure responsive member and plural elements
therein for detecting various unique positions of the movable pressure
responsive member, said movable pressure responsive member being responsive
to air pressure from said source of breathable air to assume said various
unique positions as the air pressure from said source of breathable air
diminishes; wherein the progressive pressure responsive device is in fluid
communication with the fluid line intermediate the first stage regulator and
the source of breathable air, and
signal apparatus energized by said movable pressure responsive member to
provide unique signals at each of said unique positions in order to warn a
user of impending depletion of the air supply.
19. A breathing apparatus, comprising:
a pressurized breathable air supply source,
an air pressure level indicator apparatus including
a housing having first and second inlet openings and first and second
pressure passages therein, wherein the first passage is in fluid
communication with the first inlet opening, wherein the second passage is in
fluid communication with the second inlet opening, the pressurized breathable
air supply source being fluidly connected to a passage,
a progressive pressure responsive device supported in the housing and in
fluid communication with the first and second air pressure passages, wherein
the progressive pressure responsive device is movable to different discrete
positions in response to the relative air pressure levels in the first and
second air pressure passages,
a position sensor device, wherein the sensor device is operative to detect
movement of the progressive pressure responsive device to the different
discrete positions,
signal apparatus responsive to the position sensor device, wherein the
signal apparatus is operative to provide signals indicative of the different
discrete positions of the progressive pressure responsive device, and
wherein the progressive pressure responsive device is movably responsive to
air pressure of the pressurized breathable air supply source.
20. A breathing apparatus, comprising:
a pressurized breathable air supply source,
an air pressure level indicator apparatus including
a housing having an air pressure passage therein, the pressurized breathable
air supply source being fluidly connected to the passage,
a progressive pressure responsive device including a single piston slidably
supported in the housing, wherein the piston is movable between first and
second positions, and wherein the piston has a step therein providing a
larger first portion and a smaller second portion, the second portion exposed
to air pressure in the passage,
a spring in the housing biasing the piston toward the second position,
wherein the piston is movable to different discrete positions in response to
the relative pressure level in the passage,
a position sensor device including plural detector elements operative to
detect different positions of the piston between the first and second
positions,
signal apparatus responsive to the position sensor device, wherein the
signal apparatus is operative to provide signals indicative of the different
positions of the piston, and
wherein the piston is movably responsive to air pressure of the pressurized
breathable air supply source.
K
Ken Snell [MVP]
If you're not using an import specification that you created and stored in
ACCESS, then ACCESS will use a comma as the delimiter. What part of the data
is actually being imported?
What do you want the data to look like when it's imported into ACCESS? All
of what you posted is to be in one field in one record? Or as multiple
records, one for each "line" in the original text.
What is the format of the existing table into which you're trying to import
the data?
Yes, you can link to a csv file as a table in ACCESS, though I'm not sure if
that will be better for you.
--
Ken Snell
<MS ACCESS MVP>
ACCESS, then ACCESS will use a comma as the delimiter. What part of the data
is actually being imported?
What do you want the data to look like when it's imported into ACCESS? All
of what you posted is to be in one field in one record? Or as multiple
records, one for each "line" in the original text.
What is the format of the existing table into which you're trying to import
the data?
Yes, you can link to a csv file as a table in ACCESS, though I'm not sure if
that will be better for you.
--
Ken Snell
<MS ACCESS MVP>