Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you change format on Excel .CSV file to import to access
I have downloaded a .CSV file format into Excel. Then I try to import to
Access and it says it is in the incorrect format. I did this before and remember I had to define the colums and things in Excel before importing to access. Can anyone point me in the right direction im so frustrated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you change format on Excel .CSV file to import to access
it sounds like you are importing into an existing table, make the column
headings in excel match the field names, format the columns by right-clicking on the column letter and pick format cells "Matt" wrote: I have downloaded a .CSV file format into Excel. Then I try to import to Access and it says it is in the incorrect format. I did this before and remember I had to define the colums and things in Excel before importing to access. Can anyone point me in the right direction im so frustrated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: wheres menu item to change file format conversion options? | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
import .CSV file to XP EXcel 2003 worksheet, the seperator is com. | New Users to Excel |