File Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 28 Jul 2005 14:28 GMT

I was exporting data to an CVS (comma Delimited File). It is not placing the
Comma's or Quote's in the file? Has anyone run into this?

Reply to this Message

Ken Snell [MVP] - 28 Jul 2005 16:35 GMT

You don't give us enough information to even hazard a guess. How are you
exporting? What are you exporting? When are you exporting? etc.

Signature

Ken Snell
<MS ACCESS MVP>

>I was exporting data to an CVS (comma Delimited File). It is not placing
>the
> Comma's or Quote's in the file? Has anyone run into this?

Reply to this Message

Tim - 28 Jul 2005 16:53 GMT

In Access I have selected the Tables and the table I want, Right click and
select export, changed the save as type to "Text
File(*.txt;*.csv;*.tab;*.asc)"

> You don't give us enough information to even hazard a guess. How are you
> exporting? What are you exporting? When are you exporting? etc.
>
> >I was exporting data to an CVS (comma Delimited File). It is not placing
> >the
> > Comma's or Quote's in the file? Has anyone run into this?

Reply to this Message

Ken Snell [MVP] - 28 Jul 2005 17:14 GMT

What are the data types of the fields in the table: text, numeric,
date/time, etc.? Does the export wizard window open after you select the
Export item? Did you use Delimited option from that wizard window?

Signature

Ken Snell
<MS ACCESS MVP>

> In Access I have selected the Tables and the table I want, Right click and
> select export, changed the save as type to "Text
[quoted text clipped - 6 lines]
>> >the
>> > Comma's or Quote's in the file? Has anyone run into this?

Reply to this Message

Tim - 28 Jul 2005 18:27 GMT

Text and 1 numeric. The export wizrad window did not open.

> What are the data types of the fields in the table: text, numeric,
> date/time, etc.? Does the export wizard window open after you select the
[quoted text clipped - 9 lines]
> >> >the
> >> > Comma's or Quote's in the file? Has anyone run into this?

Reply to this Message

Ken Snell [MVP] - 28 Jul 2005 18:41 GMT

Let's try this approach and see what happens.

Click on the table that you want to export. Click on File | Export on menu
bar. Select "Text File(*.txt;*.csv;*.tab;*.asc)". Does the export wizard
open then?

Signature

Ken Snell
<MS ACCESS MVP>

> Text and 1 numeric. The export wizrad window did not open.
>
[quoted text clipped - 14 lines]
>> >> >the
>> >> > Comma's or Quote's in the file? Has anyone run into this?

Reply to this Message